Query to return who has approved a ticket with multiple approvers

Huyen Huynh_c89mad

My Service Desk tickets have multiple approvers (3 approvers per ticket).  What query do I use to search for who has approved?

Approvals = approved() only informs me if the entire ticket has been approved (doesn't report by individual)

Approvals = approver() returns all tickets (unapproved and approved) belonging to one approver

Approvals = pendingBy() returns all unapproved tickets belonging to one approver

I can't seem to find a way to return only the approved tickets belonging to one approver as Approvals only supports the = operator.

Suggestions?

 

 

Jack Nolddor [Sweet Bananas]

Not sure if this is what are you looking for:

Full approved issues where one of the approvals was user: username1

Approvals = approved() AND Approvals = approver("username1")

 

Pending by other users or Full approved issues where username1 already approved the issue:

Approvals = approver("username1") AND NOT Approvals = pendingBy("username1")

 

Regards