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

2007-03-21 Thread Chris Allermann
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.

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

2007-03-21 Thread Matthew Keller
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

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

2007-03-21 Thread Chris Allermann
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

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

2007-03-21 Thread Matthew Keller
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 =

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

2007-03-21 Thread Matthew Keller
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

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

2007-03-21 Thread 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 [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

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

2007-03-21 Thread 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 [EMAIL PROTECTED] wrote: Yes, that's a global. I have