<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Thanks Gene<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Is there any documentation on what's possible or am I going to have to figure this out from code?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>The TicketSQL page on the wiki doesn't seem to contain much.....</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Cheers,</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Justin</DIV><DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>------------------------------------------------------</DIV><DIV>Justin Hayes</DIV><DIV>Support Manager</DIV><DIV><A href="mailto:justin.hayes@orbisuk.com">justin.hayes@orbisuk.com</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN></SPAN> </DIV><BR><DIV><DIV>On 1 May 2007, at 16:35, Gene LeDuc wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> Hi Justin,<BR><BR> I'm pretty sure that Requestor is a group rather than an individual (a ticket can have multiple requestors, but only a single owner). You might see if there are any functions that check for group membership in TicketSQL.<BR><BR> Gene<BR><BR> At 06:35 AM 5/1/2007, Justin Hayes wrote:<BR> <BLOCKQUOTE type="cite" class="cite" cite="">Hi,<BR><BR> The customers I support (the Requestors) will be using the At A Glance screen rather than SelfService. I would like to create a saved search that will display tickets requested by the currently logged in user.<BR><BR> I know you can do Owner = '__CurrentUser__' in a search, but is there an equivalent for Requestor?<BR><BR> I've tried Requestor = '__CurrentUser__', Requestor.id, Requestor.Name, Requestor.RealName etc etc but none seem to work. Can't see anything about this on the Wiki so thought I'd ask here.<BR><BR> Thanks in advance for any help!<BR><BR> ------------------------------------------------------<BR> Justin Hayes<BR> Support Manager<BR> <A href="mailto:justin.hayes@orbisuk.com">justin.hayes@orbisuk.com</A><BR> <BR> <BR><BR> _______________________________________________<BR> <A href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" eudora="autourl"> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR> <BR> Community help: <A href="http://wiki.bestpractical.com/" eudora="autourl"> http://wiki.bestpractical.com</A><BR> Commercial support: <A href="mailto:sales@bestpractical.com">sales@bestpractical.com</A><BR><BR> <BR> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR> Buy a copy at <A href="http://rtbook.bestpractical.com/" eudora="autourl"> http://rtbook.bestpractical.com</A> </BLOCKQUOTE> <X-SIGSEP><P> <BR> -- <BR> Gene LeDuc, GSEC<BR> Security Analyst<BR> San Diego State University </P></X-SIGSEP></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>