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

[Ruslan Zakirov]

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
>



-- 
Best regards, Ruslan.