[rt-users] custom query - RT at a Glance - SOLVED
Elton S. Fenner
elton.fenner at al.rs.gov.br
Wed Oct 7 11:09:57 EDT 2009
Thanks Kevin!
Exactly what I wanted.
Elton
Em 07-10-2009 11:41, Kevin Falcone escreveu:
> On Wed, Oct 07, 2009 at 10:58:16AM -0300, Elton S. Fenner wrote:
>
>> Hi,
>>
>> Our team who work on tickets frequently are requestors of tickets to.
>> I know about the<server>/SelfService, but what I would like is to have
>> a custom query at RT at a Glance.
>>
>> I'm trying to create a query to show stalled tickets who __CurrentUser__
>> is requestor.
>> When I try a query Owner = __CurrentUser__ it works fine (Owner =
>> '__CurrentUser__' AND Status = 'stalled').
>>
>> But when I try this: "Requestor.EmailAddress LIKE '__CurrentUser__' AND
>> Status = 'stalled'" (without doble quotes) nothing is shown and in the
>> same query when I use instead of __CurrentUser__ logon name it works.
>>
> Try Requestor.id = '__CurrentUser__', CurrentUser is an id, not a
> login name or email address.
>
> -kevin
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
> !DSPAM:8,4acca8ba283641340110847!
>
>
>
> ------------------------------------------------------------------------------------
> Caro usuário:
> * Se este e-mail não foi corretamente classificado como spam, encaminhe para spam at dspam.al.rs.gov.br ou apenas Spam.
> * Se este e-mail foi erroneamente classificado como spam, encaminhe para notspam at dspam.al.rs.gov.br ou apenas Inocente.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091007/22b548c0/attachment.htm>
More information about the rt-users
mailing list