Using _CurrentUser_ in a saved search?

I have a search I’m trying to fix that currently looks like:

Queue = ‘Helpdesk’ and Owner = ‘aavriette’ and LastUpdated < ‘7
days’ and LastUpdated > ‘-7 days’

The LastUpdated thing smells like a hack to me, but it seems to work.
I’d like to be able to say “and Owner = ‘CurrentUser’” but when I
do, I get nothing. If I remove the ticks around currentuser, I get

Error near → CurrentUser ← expecting a VALUE in ’ Queue = ‘Helpdesk’
AND Owner = CurrentUser [ … ]

Since we have TPS reports to file weekly, I’m trying to give our users
a “rolling 7 day window” of what they’ve updated in the last week. I
want to then save the search, name it appropriately, and then add it
to their “at a glance” page so they all have it and don’t have to work
too hard to get this information.

How do I properly use the CurrentUser variable? By the way, I did look
at the wiki, and it has the stuff that got me to where I am (it was
helpful, like letting me know I could use “negative days”) and I used
the “google trick” on the mailing list archives, but I didn’t see
anything appropriate. Apologies in advance if this has been answered;
I’ll update the wiki with this as an example (seems useful to me) when
I get it figured out.

Many thanks,
alex

Alex J. Avriette
This email should not be considered authoritative or even truthful.
aim:avriettea – skype:avriette – linkedin:http://xrl.us/bfdyi
858-367-7293

IIRC it should be 2 _ characters.

Alex J. Avriette wrote:

No results with two underscores, either.

alexOn Jan 30, 2008, at 1:07 PM, Drew Barnes wrote:

IIRC it should be 2 _ characters.

Alex J. Avriette wrote:

I have a search I’m trying to fix that currently looks like:

Queue = ‘Helpdesk’ and Owner = ‘aavriette’ and LastUpdated < ‘7
days’ and LastUpdated > ‘-7 days’

[snip]

How do I properly use the CurrentUser variable? By the way, I did
look at the wiki, and it has the stuff that got me to where I am
(it was helpful, like letting me know I could use “negative days”)
and I used the “google trick” on the mailing list archives, but I
didn’t see anything appropriate. Apologies in advance if this has
been answered; I’ll update the wiki with this as an example (seems
useful to me) when I get it figured out.

Alex J. Avriette
This email should not be considered authoritative or even truthful.
aim:avriettea – skype:avriette – linkedin:http://xrl.us/bfdyi
858-367-7293

You can’t used CurrentUser in a saved search.On 1/30/08, Alex J. Avriette avriette@gmail.com wrote:

I have a search I’m trying to fix that currently looks like:
Queue = ‘Helpdesk’ and Owner = ‘aavriette’ and LastUpdated < ‘7 days’ and
LastUpdated > ‘-7 days’

The LastUpdated thing smells like a hack to me, but it seems to work. I’d
like to be able to say “and Owner = ‘CurrentUser’” but when I do, I get
nothing. If I remove the ticks around currentuser, I get

Error near → CurrentUser ← expecting a VALUE in ’ Queue = ‘Helpdesk’ AND
Owner = CurrentUser [ … ]

Since we have TPS reports to file weekly, I’m trying to give our users a
“rolling 7 day window” of what they’ve updated in the last week. I want to
then save the search, name it appropriately, and then add it to their “at a
glance” page so they all have it and don’t have to work too hard to get this
information.

How do I properly use the CurrentUser variable? By the way, I did look at
the wiki, and it has the stuff that got me to where I am (it was helpful,
like letting me know I could use “negative days”) and I used the “google
trick” on the mailing list archives, but I didn’t see anything appropriate.
Apologies in advance if this has been answered; I’ll update the wiki with
this as an example (seems useful to me) when I get it figured out.

Many thanks,
alex


Alex J. Avriette
This email should not be considered authoritative or even truthful.
aim:avriettea – skype:avriette – linkedin:http://xrl.us/bfdyi
858-367-7293


The rt-users Archives

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

I have a search I’m trying to fix that currently looks like:

Queue = ‘Helpdesk’ and Owner = ‘aavriette’ and LastUpdated < ‘7
days’ and LastUpdated > ‘-7 days’

The LastUpdated thing smells like a hack to me, but it seems to
work. I’d like to be able to say “and Owner = ‘CurrentUser’” but
when I do, I get nothing. If I remove the ticks around currentuser,
I get

Error near ->CurrentUser<- expecting a VALUE in ’ Queue =
‘Helpdesk’ AND Owner = CurrentUser [ … ]

Since we have TPS reports to file weekly, I’m trying to give our
users a “rolling 7 day window” of what they’ve updated in the last
week. I want to then save the search, name it appropriately, and
then add it to their “at a glance” page so they all have it and
don’t have to work too hard to get this information.

CurrentUser will work when on the At a Glance page, but isn’t
interpolated when running a normal
saved search (it gets preprocessed before going to the TicketSQL code).
If you save it and add it to At a Glance you should see it work.

-kevin

From: “Alex J. Avriette” avriette@gmail.com
Date: 30Jan, 08 6:52:44 PM EST
To: Kevin Falcone falcone@bestpractical.com
Subject: Re: [rt-users] using CurrentUser in a saved search?

CurrentUser will work when on the At a Glance page, but isn’t
interpolated when running a normal
saved search (it gets preprocessed before going to the TicketSQL
code).
If you save it and add it to At a Glance you should see it work.

Folks, adding the double-underscores worked. The query is now exactly:

Queue = ‘Helpdesk’ and Owner = ‘CurrentUser’ and LastUpdated <
‘7 days’ and LastUpdated > ‘-7 days’

if anyone’s curious. Kevin’s right, you can’t see the “show results”
on the edit page, but it works just fine on At a Glance, which is
what I needed for my users. Thanks a bunch, folks.

cheers,
alex


Alex J. Avriette
This email should not be considered authoritative or even truthful.
aim:avriettea – skype:avriette – linkedin:http://xrl.us/bfdyi
858-367-7293