[rt-users] using _CurrentUser_ in a saved search?
From: Alex J. Avriette [EMAIL PROTECTED] Date: 30Jan, 08 6:52:44 PM EST To: Kevin Falcone [EMAIL PROTECTED] Subject: Re: [rt-users] using _CurrentUser_ in a saved search? On Jan 30, 2008, at 3:38 PM, Kevin Falcone wrote: __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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] using _CurrentUser_ in a saved search?
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' 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] using _CurrentUser_ in a saved search?
No results with two underscores, either. alex On 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] using _CurrentUser_ in a saved search?
You can't used __CurrentUser__ in a saved search. On 1/30/08, Alex J. Avriette [EMAIL PROTECTED] 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] using _CurrentUser_ in a saved search?
On Jan 30, 2008, at 12:54 PM, 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' 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 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com