[rt-users] TicketSQL -- how to search for a member of a group?

Barton Chittenden barton at bywatersolutions.com
Fri Jan 13 15:07:07 EST 2017


My question touches on some issues that are similar to "Search for open
tickets last updated by requestor" (https://lists.gt.net/rt/users/51042)

I have a search set up for closed bugs updated within the last day, where
the update is not by the current user:

Owner = '__CurrentUser__'
AND LastUpdatedBy != '__CurrentUser__'
AND LastUpdated > '1 day ago'
AND Status != 'new'
AND Status != 'open'
AND Status != 'onhold'
AND Status != 'needsinfo'

We have this as part of a dashboard that's sent daily to staff -- we want
to alert the staff of any closed tickets that some requester has touched.

That's all well and good, but there are times when tickets get mass-updated
by members of our staff, and because that staff member is not
__CurrentUser__, we get spammed by those.

We do have a group called 'Staff', so I should be able to do something like
this:


Owner = '__CurrentUser__'
AND LastUpdatedBy != '__CurrentUser__'
AND LastUpdatedBy  IS NOT A MEMBER OF STAFF
AND LastUpdated > '1 day ago'
AND Status != 'new'
AND Status != 'open'
AND Status != 'onhold'
AND Status != 'needsinfo'

... I just need to know how to express " IS NOT A MEMBER OF STAFF" as
TicketSQL.

... this was touched upon as a possible solution for "Search for open
tickets last updated by requestor", but the syntax wasn't given.

Thanks,

--Barton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20170113/8f045c31/attachment.html>


More information about the rt-users mailing list