RT Query help with comments

RT Users
1

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

2

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…

MattOn Wed, Mar 4, 2009 at 10:15 AM, Kenneth Crocker KFCrocker@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

3

Matt,

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

Kenn
LBNLOn 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@lbl.gov mailto:KFCrocker@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@bestpractical.com
<mailto:sales@bestpractical.com>


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com