Query to return who has approved a ticket with multiple approvers

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?

1 answer

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks for the quick response - unfortunately, I don't think NOT works with approvals. Both the queries below return the same results:

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

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

Suggestions?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Hmmm have you Script Runner for Jira available within your instance?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Yes, I have ScriptRunner.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.