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 <kfcroc...@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: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com