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