[rt-users] search by CommentedOnBy?

[Payam Poursaied]

You could start by database

select 
Transactions.id,ObjectType,ObjectId,Type,Transactions.Created,Name,EmailAddr
ess from Transactions 
inner join Users on Users.id=Transactions.Creator
where ObjectType='RT::Ticket' and  Type='Comment' and 
Transactins.Created>='YYYY-MM-DD HH:MM:SS' and
Transactions.Created<='YYYY-MM-DD HH:MM:SS';

But be aware of 2 things:
First: the time is not your localtime, it is GMT0
second: if someone rather than your support team is allowed to comment on
tickets, you would have them in the report




Date: Thu, 10 Feb 2011 16:25:10 -0500
From: Chris Hall <hiro24 at gmail.com>
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] search by CommentedOnBy?

I hate to necro an old, dead thread but.. this seems to have come up again..
from two separate people.  I did figure out if I edited the advanced section
and added __CommentedOnBy__ I could at least see who the last person was to
comment on a ticket, but here's my current problem:

Helpdesk manager person has some software that spits out how many calls a
given worker does, and wants to compare this with the RT records.  For
example, Worker A takes 54 calls in a night.  Helpdesk manager person wants
to check the RT records to see if he has made 54 comments for that given
night.  Kind of a making sure ppl are doing what they're supposed to be
doing.

So sometime before the end of the month, I need to figure out a way to form
a query to show all comments in a given month.  Maybe not "show" them, but
just a list to say... Worker A commented on the following tickets this
month.

Does anybody have any suggestions where I could start with something like
this?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5180 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110211/dcb0473c/attachment.bin>