Query for specific checkboxes being checked in a custom field

[Casey Jones]

I have a custom field "Review" for my "core" Project. In that field are 4 checkboxs. "Tested" "Design Reviewed" "Code Reviewed" & "Needs Review".

I'm trying to set up individual filters for the design dashboard, Dev dashboard, and QA Dashboard. So I need a query that tells me if just "design reviewed" is unchecked, just "tested" is unchecked, and just "code reviewed" is unchecked when items are in Awaiting Acceptance.

I gotten this far,

Project = CORE AND "Review" is EMPTY AND status = "Awaiting Acceptance"

But this only tells me if none of them are checked where as I need indivdual checkboxes.

Please Help

[davesoft11]

Thanks.

The short answer here for the syntax for querying checkboxes via JQL is:

MyCheckbox is not empty

Hope this helps.

[kuldeep Singh]

@Casey Jones ,

For this requirement, i think this plugin will work best,

https://marketplace.atlassian.com/apps/1211562/checklist-for-jira?tab=overview&hosting=cloud 

Please check these and let me know for more information.

Thanks.

[Illia Chekan]

I would suggest changing those checkboxes into statuses, since I'm not sure checkboxes make sense here, statuses would be way more representative and easy to filter by

[Ignacio Pulgar]

Just Tested is unchecked:

Project = CORE AND status = "Awaiting Acceptance" AND Review = "Design Reviewed" AND Review = "Code Reviewed" AND Review = "Needs Review" AND Review != Tested

[Jean-Francois Cartier]

so basically if you add one more option to the checkboxes you have to update your query?

It's far from being robust. Isn't there a way to get the checked/unchecked count on checkboxes?

[Michael Simmons]

Thank you @Ignacio Pulgar for that info. 👍

[Nelleke]

Mmmh. This does not work for me. I have one check box "Yes".  It displays "Yes" in the ticket, dashboards and filters.

Reviewed = Yes works beautifully, but I cannot get the reverse to work. Any of the options below returns an empty set and I know I have plenty that don't have it set. I usually want to look a the ones that don't have it set. What am I missing?

• Reviewed != Yes
• NOT (Reviewed = Yes)
• !Reviewed = Yes
• Reviewed IS EMPTY
• Reviewed NOT IN (Yes)

[Nelleke]

I think I found it.

We recently added this field and older tickets don't seem to have it indexed. When I checked the box first, then searched, unchecked it on one ticket, it did find it on the Reviewed is EMPTY JQL.

A stackoverflow post suggested the project may need a reindex.

https://stackoverflow.com/questions/4922448/search-for-issues-with-custom-field-of-type-multi-checkboxes-not-ticked

[Thomas Marshall - Network]

This will bring up any checklists that have NO checklist items entered. 

Checkbox = EMPTY

IF you want to see things that aren't checked use the following:

type = "Task" and !("ChecklistName[Checkboxes]" = Yes)

-*Where Yes above is the item you're looking to see is unchecked. However, it wants to be sure something else IS CHECKED.

ALTERNATE

type = Task AND NOT "ChecklistName[Checkboxes]" = Yes

NOTE - I use Jira Cloud