Hey community,
I have a number of workflows including approval steps. Unfortunately there are many different user picker fields used in the various workflows and many of these are set using automation. From time to time issues get stuck because the used approver field in the approval step is empty.
In order to fix these I want to be able to filter them. I have come up with this initial JQL:
approvals = pending()
This gives me all issues waiting for approval. But I cannot add another clause checking if the relevant "approver" field is empty. There are JQL functions like "pendingBy()" but these require a user added. If I could use "IS EMPTY" with this JQL function things should be sorted but this operator is not supported, something like this:
approvals = pending() AND pendingBy() IS EMPTY
I could set the "approver" field mandatory in the transition to the approval step but that does not guarantee that it is not cleared while in the status
Any ideas how to check if the used approver field is empty or not in this situation?
Cheers,
// Svante
