[rt-users] search by CommentedOnBy?

[Chris Hall]

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?

On Tue, Jan 4, 2011 at 9:56 AM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Tue, Jan 04, 2011 at 08:32:21AM -0500, Kris Germann wrote:
> > -----Original Message-----
> > From: rt-users-bounces at lists.bestpractical.com
> > [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin
> Falcone
> > Sent: Tuesday, January 04, 2011 8:24 AM
> > To: rt-users at lists.bestpractical.com
> > Subject: Re: [rt-users] search by CommentedOnBy?
> >
> > > > On Mon, Jan 03, 2011 at 06:16:42PM -0500, Chris Hall wrote:
> > > >    That's close I think, but not quite what I'm looking for. I
> couldn't
> > get your line to work..
> > > >    although I could see how it's not exactly what they're looking
> for.
> > They want to search for
> > > >    everything a particular user has commented on on the current day.
> > That would potentially show
> > > >    things a user had commented on in a previous day, and another
> person
> > had commented on today.
> >
> > > CommentedOnBy is not a valid RT 3.8 search term
> > > The search you're trying to build goes against Transactions and would
> > > require code.
> > Which installation is this specific to? I am running RT Ver 3.8.8 (On
> > Freeside 2.1.2cvs) and my terms of CommentedOnBy = 'user1' LastUpdatedOn
> =
> > 'today' appear to work fine... Or is it something more specific.
>
> Sounds like you have custom code
>
> $ rt/3.8 (3.8-trunk)$ grep -r CommentedOnBy lib/
>
> -kevin
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110210/00bb29c1/attachment.htm>