Community
Q&A
Atlassian Automation
Questions
Automation related issues condition match JQL throws errors when checking for null/empty value

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

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?

Screenshot 2024-06-14 at 9.07.33 AM.png

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

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

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

Comment

Yup that worked, amazingly simple, thanks!

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

Comment

Like • Bill Sheboy likes this

0 votes

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

Nicolas

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

Comment

Sure, apologies, here is the error I get:

Screenshot 2024-06-14 at 12.31.41 PM.png

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!

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

Comment

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

Nicolas

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

Comment

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

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

Comment

Was this helpful?

Thanks!

Atlassian Automation

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events