[rt-users] QueryBuilder: find where LastUpdatedBy 'unprivileged'

Raed El-Hames rfh at vialtus.com
Wed Aug 12 12:02:19 EDT 2009


Allen;

Can I also suggest a working practice we adopt and maybe relevant to 
your question, when we are waiting on a customer response we set a 
ticket status to stalled , and we have a global scrip to set a ticket 
status to open  on correspondence.
So when we look for tickets where the last correspondence was from a 
customer we simply look for
(Status = 'open') AND (  Owner = '__CurrentUser__' ) ; again a process 
we have is if a ticket is owned its no longer 'new',

Apologies if its not relevant.

Regards;

Roy

Ruslan Zakirov wrote:
> Hi Alllen,
>
> Try LastUpdatedBy.EmailAddress not like '@...'. I think it works in
> the latest RT.
>
> But there is no LastUpdatedBy IS AN UNPRIVILEGED USER thing.
>
> On Wed, Aug 12, 2009 at 4:02 AM, Allen<allen+rtlist at crystalfontz.com> wrote:
>   
>> We would like to make a Saved Search that will show us all tickets
>> where LastUpdatedBy was a client as opposed to one of our support
>> staff.
>>
>> What would the correct TicketSQL be to get something like:
>>
>> (Status = 'open' OR Status = 'new' ) AND (  Owner = '__CurrentUser__' ) AND
>> (
>>  LastUpdatedBy IS AN UNPRIVILEGED USER
>>  OR
>>  LastUpdatedBy.User.Email Not like '@ourdomain.com'
>> )
>>
>> Is such a query possible in TicketSQL?
>>
>> I searched the web and could only find an announcement of release
>> 3.6.7 where one of the change notes was:
>>
>>    "* add id to the list of users' properties you can search by [ruz]"
>>
>> but I don't know how one actually searches on a user's property in the
>> QueryBuilder.
>> _______________________________________________
>> 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
>>
>>     
>
>
>
>   



More information about the rt-users mailing list