@MoroSystems Support, the "is" operator is not supported for Approvals field.
@Josip Šćirek, the only thing I can suggest right off is to use the "pending()". If I find a better solution I will add here.
@Jack Brickey thanks for correction, it slipped out of my mind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For this, we use the 'approvers' field in JQL.
Problem: However, by default the field is not searchable, which is why it does not work in JQL.
Solution: A Jira admin can update the custom field to be "searchable". It may require reindexing.
BUT, I agree that `approvals()` should have other functions, such as != or `is not`.
For example, I would like to search for items which have `approvers` but have not been approved. Checking `approval=pending()` is not enough since that only accounts for ones where the current status is an approval status.
And this doesn't work:
You get the same result with 'and' or 'and not'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe you can try Approvers (field) instead of Approval (function).
Something like this works on our instance:
status = "Awaiting approval" and Approvers in (EMPTY)
Note 1: "Awaiting approval" is the status of your workflow where the "Approvers" are set.
Note 2: The "Approvers" field is available when "Service Desk" is installed.
Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have Jira Service Desk Cloud and there is no "Approvers" in JQL.
In order to search for a certain approver, you need to query
Approvals = approver("username")
And this way, you can't search for an empty Approver field. Or at least, I don't know how :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Josip,
I think you ar looking for "is EMPTY". Please, try this JQL:
status = "Awaiting approval" AND Approvals is EMPTY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I get message:
The operator 'is' is not supported by the 'Approvals' field. Unknown Approval function. Please use one of supported functions: pending, pendingBy, approved, approver, myApproval, myPending
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, same here. They really need something to indicate approvers is empty, like maybe just isempty() or approvercount() = 0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.