JQL on specific "Definition of Ready" options

[Some Guy]

Hi all,

If I setup "definition of ready" checkboxes, can I create a JQL expression to find the ones that have a particular checkbox checked or not?

If so, can someone provide an example of the syntax?

I tried

"Definition of Ready" != option18
"Definition of Ready" NOT IN (option11, option 18)
"Definition of Ready" != "Literally the name of the/checkbox"

Also tried with the ID: cf[xxxxx]

[Some Guy · Accepted solution]

Thank you, that's it!

... AND "Definition of Ready" = itemSearch("name = my/custom checkbox name", "completion = false")

For all issues with this perticular "my/custom checkbox name"

Accepted answer from user @Maxime Lefebvre _Okapya_ on Feb. 18, 2022.

[kuldeep Singh]

@Some Guy 

I suggest you to use this plugin, 

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

This plugin has all required options compared to the checkboxes.

Please let me know if you need more information on this.

Thanks.

[Some Guy]

I am no admin and there is no chance our admins will install any plugins. Especially if they charge a fee.

[Trudy Claspill]

Hello @Some Guy 

Welcome to the community.

Take a look at the response on this post and see if that works for you.

https://community.atlassian.com/t5/Jira-questions/Query-for-specific-checkboxes-being-checked-in-a-custom-field/qaq-p/618823

[Some Guy]

This does not work for me, if I make this query nothing shows up:

"Definition of Ready" != "Some/String"

Maybe the slash is a problem?

I would just make a query with all possible combinations but there are 19 options (atm) and therefore 19^2=361 combinations. Little bit overhead.

[Peter DeWitt]

@Some Guy , The syntax you have shown should work.

I just tried this in my instance and the following JQL works for checkbox fields.

"Custom Field Name" in (selection1,selection2,selection3)

"Custom Field Name" not in (selection1,selection2,selection3)

where Selection 1,2,3 are the names of the options. When using JQL, Jira should auto-offer the correct options for the checkbox field.

-pjd

[Some Guy]

This does not work on my side. Also Jira does not auto offer the elements in the "Definition of Ready" list. I get only a list of functions:

• allItemsChecked()
• allItemsUnchecked()
• allMandatoryItemsChecked()
• checklistCompletion("")
• itemAssigendToMe()
• itemDueDate("")
• itemSearch("")

Maybe to mention I want to search for an optional/additional DoR. I also tried the last option (itemSearch("")) with the name of the option but it does not find anything. It is listed under "Project -> Issue (Epic) -> Tab "Standards" -> "Definition of Ready" List

[Peter DeWitt]

A few more questions:

1. What type of field is this? Is it a standard Jira Checkbox field or one specific to an app.
2. Where are you trying to enter this query? I assume in the standard search? Can you confirm? Issues -> Search for Issues

-pjd

[Some Guy]

1. I assume it is standard Jira. It in the Epic within the section "Details" and there are Tabs (General, Standards), there it is located.

When I create a new issue and the type is Epic there are also 3 tabs, one of them is "Standards" and there are the DoR's

2. You are right, I am making a JQL query in "Issues"->"Search for Issues" and of course the advanced search

[Peter DeWitt]

Can you take a screen capture of the field? Got to settings-> Issues -> fields; find the field with the checkboxes and take a screen capture.

[Maxime Lefebvre _Okapya_]

Hi @Some Guy ,

It appears that your field "Definition of Ready" is from our App Checklist for Jira. The functions you are referring to are from our Server plugin.

Here the documentation on our JQL functions.

Using the following syntax will only return whether the item exists in the checklist or not:

"Definition of Ready" = "Item name"

If you want to filter if the item is checked, you can use the following function:

"Acceptance Criterias" = itemSearch("name=Item name", "completion=true")

Also, if the item name contains formatting, you need to include the formatting in the search, example:

"Acceptance Criterias" = itemSearch("name=Upgrade [Angular](www.angularjs.org) dependency (*)", "completion=true")

The itemSearch function might be a little verbose, but it's a powerful tool that allows to search for items with a specific set of values.

I hope this helps! :)

Regards

[Some Guy]

Thank you, that's it!

... AND "Definition of Ready" = itemSearch("name = my/custom checkbox name", "completion = false")

For all issues with this perticular "my/custom checkbox name"

[Peter DeWitt]

@Maxime Lefebvre _Okapya_ , Thanks for jumping in! - I figured it was an add-on of some sort just didn't know which one.

[Some Guy]

I am new to Jira and it's world, so I didn't figured it out. I am also only a user and don't see any of the plugins/addons (or maybe there is a way to see them?).

Thank you very much for your help, I hope this will help someone too.

I will answer myself and reference to @Maxime Lefebvre _Okapya_ and his answer, so I can put the accepted answer at top.