List tickets I ever transacted on?

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@ucdavis.edu : Sysadm Motto: rm -fr /MyLife

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
LBNLOn 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@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@bestpractical.com

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

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.)

Pretty sure you can’t do this in RT itself, you’ll have to query the
database directly.

First find out your numeric user id with something like "select id,name from
Users where name like ‘%paul%’. Let’s say your ID is 42.

Then you can do “select distinct ObjectID from Transactions where
Creator=‘42’ and ObjectType=‘RT::Ticket’ order by ObjectID”

Voila, list of ticket numbers you’ve transacted on.
– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================

Hi ;

If you interested I have modified my Query Builder a couple of years ago
adding UpdatedBy as a search criteria ; the changes are simple and not
sure why the RT developers do not include this function , I am afraid I
do n’t know how to do patches to RT , but attached are the code changes:
( works for rt 3.6.3 – But I think will work for rt-3.8)

I am sure you are aware that you should not do any changes to share/html
or lib/RT and any changes its better done in local/html and local/lib …

Good luck and hope it helps;

Roy

Paul Hirose wrote:

UpdatedBy.txt (2.34 KB)