Validate all checkboxes on my custom field

Question

I am on JIRA version 7.12.3 and was wondering how to go about validating a custom checkbox field in my workflow, to make sure the user selects all checkboxes before transitioning to the next status.

i tried the unique field value validator but am getting stuck when needing to put in a JQL query?

in my case i have 3 check boxes in my custom field and all need to be checked.

Andrew Laden · Answer

Unique field validator isnt want you want here. That is for counting the unique possible values for a field. Useful for making sure you arent adding too many labels, or something.

As for what validator to use, thats a good question. Depends on what Addons you have available.

Any of the scripting ones (scriptrunner, power scripts) would work.

JSU could work.

I'm sure there are others. What do you have?

Warren Kent · Answer

Thanks for the help - i did the above, but seems its not being validated in my workflow. I want to make sure that the user has to select all 3 checkboxes before it can move to the next status.

What i had was:

* JQL: "checkbox" = "option1" AND "checkbox" = "option 2" AND "checkbox" = "option 3"
* Issue Field: Confirm Resolution
* Count: 0
* Error Message: Please confirm you have resolved the requirement by checking all 3 boxes.

Do i need to do something else for it to work? i tried adding the field required validation in the same step, but still doesnt require me to check all 3 boxes.

Andrew Laden · Answer

Checkboxes in JQL are searched based on the options checked. If the box is checked, then the field equals that value.

For example. if your checkboxes have 3 options. (call them "option1" "option 2" and "option 3"

Then a JQL to make sure that all 3 are checked would be

"checkbox" = "option 1" AND "checkbox" = "option 2" AND "checkbox" = "option 3"