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 <falc...@bestpractical.com>wrote: > On Tue, Jan 04, 2011 at 08:32:21AM -0500, Kris Germann wrote: > > -----Original Message----- > > From: rt-users-boun...@lists.bestpractical.com > > [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin > Falcone > > Sent: Tuesday, January 04, 2011 8:24 AM > > To: rt-users@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 >