[rt-users] search by CommentedOnBy?

Kevin Falcone falcone at bestpractical.com
Tue Jan 4 08:24:05 EST 2011


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.

-kevin

>    On Mon, Jan 3, 2011 at 5:01 PM, Kris Germann <[1]kris_germann at 295.ca> wrote:
> 
>      Under *Reports*, you can choose *Advance Ticket Search* which should call on
>      freeside/rt/Search/Build.html depending on how you*ve got your RT set up
> 
>      After this (I find) it*s easier to click over *Advanced*, beside Edit Search and Calendar;
>      then just enter your search terms. If I wanted to search for all tickets CommentedOnBy
>      myself, I*d write:
> 
>      CommentedOnBy = *kris* AND LastUpdated = *today* where *kris* is the rtuser id and
>      LastUpdated is the date you wish to search A bit hazy on the date format though, I believe
>      it*s unixtimestamp based
> 
>      Additionally, CommentedOnBy = *kris*, would pull up ALL comments by user *kris* from the
>      history of your RT installation until the second you clicked *Show Report* J
> 
>      Also, a wider search would be *LastUpdatedBy in which would would replace CommentedOnBy with
>      this and it would pull up status changes, comments, replies, etc for a specific user, or for
>      all users chronologically
> 
>      Thanks
> 
>      Kris Germann
>      Supervisor, Sales & Technical Support
>      Fibernetics Corporation
>      [2]freephoneline.ca
>      605 Boxwood Drive
>      Cambridge ON, N3E1A5
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110104/586151f0/attachment.sig>


More information about the rt-users mailing list