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.
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.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
I keep getting the following error message when I try it:
Unknown field: CC.id
Any suggestions?On 3/21/07, Matthew Keller kellermg@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.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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@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.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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@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.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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@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 CurrentUserThe only thing that worked for me was something like Cc LIKE ’
johndoe@domain.com’ . Cc.id = ‘CurrentUser’ comes up with Unknown
field: Cc.id (in query builder)On 3/21/07, Matthew Keller kellermg@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@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@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@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@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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@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@domain.com' . Cc.id = '__CurrentUser__' comes up with Unknown > field: Cc.id (in query builder) > > On 3/21/07, Matthew Keller <kellermg@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@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@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@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@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly > Media. > Buy a copy at http://rtbook.bestpractical.com >
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@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@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@domain.com' . Cc.id = '__CurrentUser__' comes up with Unknown > field: Cc.id (in query builder) > > On 3/21/07, Matthew Keller <kellermg@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@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@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@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@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly > Media. > Buy a copy at http://rtbook.bestpractical.com >
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@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@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@domain.com' . Cc.id = '__CurrentUser__' comes up > with Unknown > > field: Cc.id (in query builder) > > > > On 3/21/07, Matthew Keller <kellermg@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@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@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@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@bestpractical.com > > > > > > Discover RT's hidden secrets with RT Essentials from > O'Reilly > > Media. > > Buy a copy at http://rtbook.bestpractical.com > > > >