Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL requiring all options of checkbox field?

Hi,

I'm trying to write an automation rule (with either SD native automation or Automation Lite) to alert users if all values in a custom multi-select checkbox field were not selected. I'm getting tripped up because I need it to run if not all values were checked, whether that means none of them were checked or only some of them were checked.

Alternately we do have the JMWE add-on, which includes the Scripted (Groovy) Validator, but I'm not confident enough to write a non-declarative validation rule that would require all of the values to be selected. I've found the below helpful ScriptRunner validator, but we don't have that add-on.

cfValues['Please acknowledge'][0].getValue() == 'option1'
cfValues['Please acknowledge.'][1].getValue() == 'option2'

 Thanks in advance!

2 answers

Hey there Alexandra,

With Automation for Jira, you can use the "size" property of your custom field value. So in your case, you'd want to add a Compare condition that matches the number of selected options.

image.png

Hope that helps!

Cheers,

Mark C

Thanks Mark, but we actually only have Automation Lite, not Pro. Your suggestion is much cleaner than what I used in the native SD automation, tho (because the values are so so long). Appreciate your help!

This helped me. Thx!

I did actually find an answer for the JQL (see below), but if anyone can make suggestions for the Groovy validator that would be greatly appreciated.

"Field" is not EMPTY AND NOT ("Field" in ("option1") AND "Field" in ("option2")

Helped me a lot. In my case I was searching for issues that do not have "QA for Cloud passed" flag:


("QA Passed for[Checkboxes]" is empty or "QA Passed for[Checkboxes]" not in ("Cloud"))

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

321 views 3 14
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you