[rt-users] RT Query help with comments

[Kenneth Crocker]

Matt,


	THANKS! I'll take a look and see what I can do.


Kenn
LBNL

On 3/4/2009 12:00 PM, Matt Hoover wrote:
> Ken-
> 
> I have customized the export report found in 
> 'share/html/Search/Results.tsv'.  I created a new file and added this 
> section to pull the last correspondence.  You could easily change it to 
> fit comments:
> 
> # #################
>     my $Transactions = $Ticket->Transactions;
>      $Transactions->Limit( FIELD => 'Type', VALUE => 'Correspond' );
>      $Transactions->OrderByCols (
>                { FIELD => 'Created',  ORDER => 'DESC' },
>                { FIELD => 'id',     ORDER => 'DESC' },
>                );
> 
>      my $last_reply = ''; 
>      my $CorrespondObj = $Transactions->First;
>      if( $CorrespondObj && $CorrespondObj->id ) {
>            $last_reply= $CorrespondObj->Content;
>      }
>    
>     $row->{'last_reply'} = $last_reply;
> # #####################
> 
>     push @rows, $row;
> 
> 
> That might help you to come up with an export anyhow.... 
> 
> Matt
> 
> On Wed, Mar 4, 2009 at 10:15 AM, Kenneth Crocker <KFCrocker at lbl.gov 
> <mailto:KFCrocker at lbl.gov>> wrote:
> 
>     To all,
> 
> 
>            So far, I've been able to develop every kind of query/report
>     my users
>     have asked for. Now someone wants a Query/report that would include the
>     comments (only. Not any email, etc.) in the results. I have not been
>     able to find that option in Query builder. Has anyone developed a query
>     that will pull up comments? Thanks.
> 
> 
>     Kenn
>     LBNL
> 
>     _______________________________________________
>     http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
>     Community help: http://wiki.bestpractical.com
>     Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
> 
> 
>     Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     Buy a copy at http://rtbook.bestpractical.com
> 
>