Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Query for specific checkboxes being checked in a custom field

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

4 answers

Thanks.

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

MyCheckbox is not empty

Hope this helps.

0 votes
kuldeep Singh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Feb 15, 2022

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

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

0 votes
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Aug 02, 2017

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

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jul 12, 2022

Thank you @Ignacio Pulgar for that info. 👍

Like Ignacio Pulgar likes this

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)

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events