[rt-users] List tickets I ever transacted on?

[Ken Crocker]

Paul,


    You'll have to run an SQL with an inner join from the Transaction 
table to do this. As far as I know, Transactional history like comments 
are not available thru Query builder.


Kenn
LBNL

On 4/6/2009 2:29 PM, Paul Hirose wrote:
> Trying to find a Query Builder or other method to list all current (not-Resolved/Rejected/Deleted) tickets that I may have been a part of.  Some tickets are owned by another staff member, but I've transacted on (either as a Comment or Reply.)
>
> I don't want to Steal the ticket, nor do I want to add myself as a CC/AdminCC since I'd like to keep the ticket issues in the RT system rather than out to my email.
>
> I'm sometimes the LastUpdatedBy, but eventually the Owner, Requestor, or possibly another staff member will Reply/Comment on the ticket and I won't be the LUB person any more.  So I couldn't use that.
>
> I could Bookmark every ticket I work on (at least those that I don't own.)  But I'm not sure that's the best way to go about it either.
>
> Ideas welcome,
> Thank you,
> PH
>
> --
> Paul Hirose          : pthirose at ucdavis.edu : Sysadm Motto: rm -fr /MyLife
> _______________________________________________
> 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
>
>