[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