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; } } }

Query for specific checkboxes being checked in a custom field

Casey Jones_rt4qyo

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

Accepted answers

All comments

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?

Illia Chekan_sw8ajt

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

kuldeep Singh_n5wn5g

@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.

Michael Simmons_k03bu0

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)

davesoft11

Thanks.

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

MyCheckbox is not empty

Hope this helps.

Welcome!

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

Quick Links

Find more posts tagged with

jira