[rt-users] 10 highest tickets I own or are CC'd on

[slamp slamp]

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 <kellermg at potsdam.edu> 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 '
> > johndoe at domain.com' . Cc.id = '__CurrentUser__' comes up with Unknown
> > field: Cc.id (in query builder)
> >
> > On 3/21/07, Matthew Keller <kellermg at potsdam.edu> 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 <kellermg at potsdam.edu> 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: sales at bestpractical.com
> >         > > > >
> >         > > > >
> >         > > > > 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: sales at bestpractical.com
> >         > >
> >         > >
> >         > > 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: sales at bestpractical.com
> >
> >
> >         Discover RT's hidden secrets with RT Essentials from O'Reilly
> >         Media.
> >         Buy a copy at http://rtbook.bestpractical.com
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070321/c28a157b/attachment.htm>