did you happen to create a custom field called <a href="http://Cc.id">Cc.id</a>? if not, how come mine comes up unknown field.<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;">Yes, that's a global. I have dozens of custom global saved searches that
<br>use this. I don't know what version it was introduced, RT 3.6.something<br>was my first (currently 3.6.3). Our "Highest priority" is actually:<br><br>(<a href="http://Cc.id">Cc.id</a> = '__CurrentUser__' OR
AdminCc.id = '__CurrentUser__' OR<br><a href="http://Requestor.id">Requestor.id</a> = '__CurrentUser__' OR Owner = '__CurrentUser__') AND<br>(Status = 'new' OR Status = 'open' OR Status = 'stalled')
<br><br><br>On Wed, 2007-03-21 at 14:34 -0400, slamp slamp wrote:<br>> when you say global what do you mean? i saved the search under "RT<br>> System's saved searches" not in My saved searches.<br>>
<br>> On 3/21/07, Matthew Keller <<a href="mailto:kellermg@potsdam.edu">kellermg@potsdam.edu</a>> wrote:<br>> __CurrentUser__ will expand properly in Global saved searches,<br>> 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<br>> now with<br>> > no luck. for some reason specifying an actual value instead
<br>> of<br>> > __CurrentUser__ works but not __CurrentUser__<br>> ><br>> > The only thing that worked for me was something like Cc LIKE<br>> '<br>> >
<a href="mailto:johndoe@domain.com">johndoe@domain.com</a>' . <a href="http://Cc.id">Cc.id</a> = '__CurrentUser__' comes up<br>> 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
<br>> up on that.<br>> ><br>> > On Wed, 2007-03-21 at 14:10 -0400, Matthew Keller<br>> 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<br>> wrote:<br>> > > > I keep getting the following error message when
<br>> I try it:<br>> > > ><br>> > > > Unknown field: CC.id<br>> > > ><br>> > > > Any suggestions?
<br>> > > ><br>> > > > On 3/21/07, Matthew Keller <<br>> <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
<br>> Allermann<br>> > wrote:<br>> > > > > > Does anybody know how to modify the "10<br>> 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
<br>> to the<br>> > search but I am<br>> > > > > > having some trouble coming up with the right<br>> TicketSQL<br>> > statement to
<br>> > > > > > make the search work.<br>> > > > > ><br>> > > > > > Any help would be appreciated.<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:<br>> <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<br>> Essentials from<br>> > O'Reilly Media.<br>> > > > > > Buy a copy at
<br>> <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>> > > > ><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
<br>> 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>> <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<br>> > Media.<br>
> > Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>> ><br>><br>><br><br></blockquote></div><br>