[rt-users] RT Query help with comments

Matt Hoover mhoover at thectogroup.com
Wed Mar 4 15:00:19 EST 2009


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> 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
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090304/4c27bb37/attachment.htm>


More information about the rt-users mailing list