when you say global what do you mean? i saved the search under "RT System's saved searches" not in My saved searches.<br><br><div><span class="gmail_quote">On 3/21/07, <b class="gmail_sendername">Matthew Keller
</b> <<a href="mailto:kellermg@potsdam.edu">kellermg@potsdam.edu</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">__CurrentUser__ will expand properly in Global saved searches, but not
<br>in personal or group.<br><br>On Wed, 2007-03-21 at 14:24 -0400, slamp slamp wrote:<br>> that wouldn't work either. i have been trying for some time now with<br>> no luck. for some reason specifying an actual value instead of
<br>> __CurrentUser__ works but not __CurrentUser__<br>><br>> The only thing that worked for me was something like Cc LIKE '<br>> <a href="mailto:johndoe@domain.com">johndoe@domain.com</a>' . <a href="http://Cc.id">
Cc.id</a> = '__CurrentUser__' comes up with Unknown<br>> field: <a href="http://Cc.id">Cc.id</a> (in query builder)<br>><br>> On 3/21/07, Matthew Keller <<a href="mailto:kellermg@potsdam.edu">kellermg@potsdam.edu
</a>> wrote:<br>> and the "AND" should be an "OR" if you didn't pick up on that.<br>><br>> On Wed, 2007-03-21 at 14:10 -0400, Matthew Keller wrote:<br>> > Sorry...
<a href="http://Cc.id">Cc.id</a> (second 'c' is lowercased).<br>> ><br>> > On Wed, 2007-03-21 at 13:46 -0400, Chris Allermann wrote:<br>> > > I keep getting the following error message when I try it:
<br>> > ><br>> > > Unknown field: CC.id<br>> > ><br>> > > Any suggestions?<br>> > ><br>> > > On 3/21/07, Matthew Keller <
<a href="mailto:kellermg@potsdam.edu">kellermg@potsdam.edu</a>> wrote:<br>> > > > blahblahblah<br>> > > > AND CC.id = '__CurrentUser__'<br>> > > ><br>
> > > ><br>> > > > On Wed, 2007-03-21 at 09:56 -0400, Chris Allermann<br>> wrote:<br>> > > > > Does anybody know how to modify the "10 highest
<br>> tickets I own" search<br>> > > > > to also include tickets you are CC'd on?<br>> > > > ><br>> > > > > I know how to make the actual modification to the
<br>> search but I am<br>> > > > > having some trouble coming up with the right TicketSQL<br>> statement to<br>> > > > > make the search work.<br>> > > > >
<br>> > > > > Any help would be appreciated.<br>> > > > > _______________________________________________<br>> > > > ><br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>> > > > ><br>> > > > > Community help: <a href="http://wiki.bestpractical.com">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
<br>> O'Reilly Media.<br>> > > > > Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>> > > ><br>> > > >
<br>> > > _______________________________________________<br>> > ><br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
</a><br>> > ><br>> > > Community help: <a href="http://wiki.bestpractical.com">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<br>> O'Reilly Media.<br>> > > Buy a copy at
<a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>><br>> _______________________________________________<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>><br>> Community help: <a href="http://wiki.bestpractical.com">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<br>> Media.<br>> Buy a copy at <a href="http://rtbook.bestpractical.com">
http://rtbook.bestpractical.com</a><br>><br><br></blockquote></div><br>