nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation: How can I check the compare a boolean value of JQL?

Brady_y9j1dr

I'm using automation to perform a "Lookup Issues" action, and in a subsequent JQL Condition using the result of that "Lookup Issues" action to determine if some other action should be performed.

The JQL uses a smart value to represent the result of the "Lookup Issues" action. The result is a list, so I'm using the .isEmpty . If the list is empty, I want to proceed. If not, I want to stop the automation gracefully (i.e. without failure).

and the resulting JQL looks like this

{{lookupIssues.isEmpty}} = true

My automation rule keeps failing, and the audit log says:

JQL Condition

No subsequent actions were performed since JQL condition did not pass due to error running JQL:

Invalid JQL: true = true

I'll also include picture to hopefully better illustrate

Screen Shot 2022-05-20 at 7.48.15 AM.png

Accepted answers

Craig Nodwell_7eve9b

Hi @Brady this should help.
Smart Values Conditional Logic

Bill Sheboy

Hi @Brady

Have you tried an advanced compare condition for this instead of a the JQL one?

I suspect this is another JQL oddity of both not being an actual SQL and the lookup issues result is not an issue field.

Kind regards,
Bill

All comments

Craig Nodwell_7eve9b

Hi @Brady this should help.
Smart Values Conditional Logic

Craig Nodwell_7eve9b

Bill Sheboy

Hi @Brady

Have you tried an advanced compare condition for this instead of a the JQL one?

I suspect this is another JQL oddity of both not being an actual SQL and the lookup issues result is not an issue field.

Kind regards,
Bill

Craig Nodwell_7eve9b

The way I'm reading it is ... it's not the JQL but the smartvalue doesn't require the "= True" it already resolves to True. The error message points to this as well.
{{lookupIssues.IsEmpty}} resolves to True or Null not necessary to include the = True

Brady_y9j1dr

Hi Craig, Thanks for your suggestion. I truly thought this would be the key, but I'm still having this issue. I've attached the Audit Log. I must be missing something silly here, or maybe this doesn't work in the way I think it does. Screen Shot 2022-05-23 at 11.04.26 AM.png

Brady_y9j1dr

@Craig Nodwell @Bill Sheboy Just want to let you both know that actually in the end a combination of both of your suggestions ended up working.

I needed to use the Smart Value Conditional Logic that Craig linked, but still I must not have been handling the result of this conditional logic correctly with my JQL. Switching from JQL to advanced compare condition enabled me to handle this correctly. Thank you both so much!

Unfortunately since you were both right, I'm not sure who's answer to accept 😬

Brady_y9j1dr

edit: looks like I can accept both. Thanks again for the help!!

Craig Nodwell_7eve9b

Hi @Brady so I just found this post.
I think your answer is in here.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud