Automation related issues condition match JQL throws errors when checking for null/empty value

[Syd Heller]

Hi all,

I have an Automation and I am trying to check on related issues that also meet another criteria (that they are not closed) but I am having trouble with the Matching JQL field.

Does anyone have any ideas what JQL I could use here?

[Bill Sheboy · Accepted solution]

Hi @Syd Heller 

The "matching JQL" for that Related Issues condition must be well-formed JQL.  That is...

<some_Jira_field> <some_operator> <some_value> ...and so on

{{issue.resolution}} cannot be on the left-hand side of the JQL as that would try to compare a value to another value.

Please try this instead:

resolution IS EMPTY

Kind regards,
Bill

[Syd Heller]

Yup that worked, amazingly simple, thanks!

[Nicolas Grossi]

@Syd Heller Could please elaborate ? What errors are you getting ? Also Resolution is empty is different than Issues not closed .

Nicolas

[Syd Heller]

Sure, apologies, here is the error I get:

Sure, they are not the same. For us, Resolution is empty would be sufficient, or Issue is not "Done" or "Declined" would work too if it's easier.

Thanks for the help!

[Nicolas Grossi]

@Syd Heller Are you sure that the issue EJ-323 meets the criteria ?

Nicolas

[Syd Heller]

I don't know, because it throws that JQL error