did you happen to create a custom field called Cc.id? if not, how come mine comes up unknown field.
On 3/21/07, Matthew Keller <[EMAIL PROTECTED]> wrote:
Yes, that's a global. I have dozens of custom global saved searches that use this. I don't know what version it was introduced, RT 3.6.something was my first (currently 3.6.3). Our "Highest priority" is actually: (Cc.id = '__CurrentUser__' OR AdminCc.id = '__CurrentUser__' OR Requestor.id = '__CurrentUser__' OR Owner = '__CurrentUser__') AND (Status = 'new' OR Status = 'open' OR Status = 'stalled') On Wed, 2007-03-21 at 14:34 -0400, slamp slamp wrote: > when you say global what do you mean? i saved the search under "RT > System's saved searches" not in My saved searches. > > On 3/21/07, Matthew Keller <[EMAIL PROTECTED]> wrote: > __CurrentUser__ will expand properly in Global saved searches, > but not > in personal or group. > > On Wed, 2007-03-21 at 14:24 -0400, slamp slamp wrote: > > that wouldn't work either. i have been trying for some time > now with > > no luck. for some reason specifying an actual value instead > of > > __CurrentUser__ works but not __CurrentUser__ > > > > The only thing that worked for me was something like Cc LIKE > ' > > [EMAIL PROTECTED]' . Cc.id = '__CurrentUser__' comes up > with Unknown > > field: Cc.id (in query builder) > > > > On 3/21/07, Matthew Keller <[EMAIL PROTECTED]> wrote: > > and the "AND" should be an "OR" if you didn't pick > up on that. > > > > On Wed, 2007-03-21 at 14:10 -0400, Matthew Keller > wrote: > > > Sorry... Cc.id (second 'c' is lowercased). > > > > > > On Wed, 2007-03-21 at 13:46 -0400, Chris Allermann > wrote: > > > > I keep getting the following error message when > I try it: > > > > > > > > Unknown field: CC.id > > > > > > > > Any suggestions? > > > > > > > > On 3/21/07, Matthew Keller < > [EMAIL PROTECTED]> wrote: > > > > > blahblahblah > > > > > AND CC.id = '__CurrentUser__' > > > > > > > > > > > > > > > On Wed, 2007-03-21 at 09:56 -0400, Chris > Allermann > > wrote: > > > > > > Does anybody know how to modify the "10 > highest > > tickets I own" search > > > > > > to also include tickets you are CC'd on? > > > > > > > > > > > > I know how to make the actual modification > to the > > search but I am > > > > > > having some trouble coming up with the right > TicketSQL > > statement to > > > > > > make the search work. > > > > > > > > > > > > Any help would be appreciated. > > > > > > > _______________________________________________ > > > > > > > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > > > > > > > > > Community help: > http://wiki.bestpractical.com > > > > > > Commercial support: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > Discover RT's hidden secrets with RT > Essentials from > > O'Reilly Media. > > > > > > Buy a copy at > http://rtbook.bestpractical.com > > > > > > > > > > > > > > _______________________________________________ > > > > > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > > > > > Community help: http://wiki.bestpractical.com > > > > Commercial support: [EMAIL PROTECTED] > > > > > > > > > > > > Discover RT's hidden secrets with RT Essentials > from > > O'Reilly Media. > > > > Buy a copy at http://rtbook.bestpractical.com > > > > _______________________________________________ > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > Community help: http://wiki.bestpractical.com > > Commercial support: [EMAIL PROTECTED] > > > > > > Discover RT's hidden secrets with RT Essentials from > O'Reilly > > Media. > > Buy a copy at http://rtbook.bestpractical.com > > > >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
