Query builder logic


#1

Hi,

I’m trying to build a custom query with Query Builder that can be
used in the global “RT at a glance” configuration. I understand how
to create the custom query but am having trouble identifying the
correct variables to use to identify the currently logged in user.

I used “[_1] highest priority tickets I own” as a model. I want to
create a single query that will show all tickets for a person if
their email address appears as Owner, Requestor, CC, or AdminCC.

If I create a custom query using the exact syntax of the of the
default query above, no tickets come up. If I replace
CurrentUser’ with my email address, it locates the tickets I own.

Can anyone offer any advice or direction to documentation explaining
how to do this?

~ Tom


#2

CurrentUser is correct way, but it works in 3.6.x only (don’t
recall exact version) and only in saved searches. The latter is a sort
of incident and have been fixed few days ago. In 3.6.7 you’ll be able
to use ‘CurrentUser’ all over the places. Patch is very simple,
you can grab it from our repository.

Note that ‘CurrentUser’ is id of the user and query you want will
look something like:

Watcher.id = ‘CurrentUser

In 3.6.6 this query should work if you’ll save it as saved search.On 6/9/08, Tom Smith aliase573201@mac.com wrote:

Hi,

I’m trying to build a custom query with Query Builder that can be
used in the global “RT at a glance” configuration. I understand how
to create the custom query but am having trouble identifying the
correct variables to use to identify the currently logged in user.

I used “[_1] highest priority tickets I own” as a model. I want to
create a single query that will show all tickets for a person if
their email address appears as Owner, Requestor, CC, or AdminCC.

If I create a custom query using the exact syntax of the of the
default query above, no tickets come up. If I replace
CurrentUser’ with my email address, it locates the tickets I own.

Can anyone offer any advice or direction to documentation explaining
how to do this?

~ Tom


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

Best regards, Ruslan.