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

[Matthew Keller]

If I did, it would say CustomField.{Cc.id}

On Wed, 2007-03-21 at 14:49 -0400, slamp slamp wrote:
> 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 <kellermg at potsdam.edu> 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 <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
>         >         >
>         >
>         >
>         
>