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.<br>
<br><div class="gmail_quote">On Mon, Jan 3, 2011 at 5:01 PM, Kris Germann <span dir="ltr"><<a href="mailto:kris_germann@295.ca">kris_germann@295.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="color:#1F497D">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…</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span style="color:#1F497D">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:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span style="color:#1F497D">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…</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span style="color:#1F497D">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’ </span><span style="font-family:Wingdings;color:#1F497D">J</span><span style="color:#1F497D"></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span style="color:#1F497D">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…</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span style="color:#1F497D">Thanks</span></p><p class="MsoNormal"><span style="color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-CA" style="color:#1F497D">Kris Germann<br>
Supervisor, Sales & Technical Support<br></span><span lang="EN-CA" style="color:#333333">Fibernetics Corporation<br><a href="http://freephoneline.ca" target="_blank">freephoneline.ca</a><br>605 Boxwood Drive<br>Cambridge ON, N3E1A5</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> <a href="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank">rt-users-bounces@lists.bestpractical.com</a> [mailto:<a href="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank">rt-users-bounces@lists.bestpractical.com</a>] <b>On Behalf Of </b>Chris Hall<br>
<b>Sent:</b> Monday, January 03, 2011 4:09 PM<br><b>To:</b> rt-users<br><b>Subject:</b> [rt-users] search by CommentedOnBy?</span></p></div><div class="im"><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">
<span style="font-size:12.0pt;font-family:"Times New Roman","serif"">Is there a way to do a search of tickets to see which tickets a given person has commented on? </span></p></div></div></div></blockquote>
</div><br>