I’ll ask my primary question first, then later explain the problem in case the solution I’m pursuing is not the best one.
What I was looking for was the ability to do the following in TicketSQL via the Advanced Query Builder:
Requestor.EmailAddress LIKE ‘someone’ and count(Requestors) > 1
This “someone” is often a Requestor on their own tickets, but I want to find where “someone” is a Redundant requestor along with another party, and remove that someone from only those tickets. I’d like to leave someone as Requestor on tickets where the someone is the ONLY requestor.
I don’t necessarily need to use TicketSQL for this if there’s another suggestion on how to remove this Requestor only when they are a redundant requestor.