Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Usage of operators '<', '=<', '>', '=>' on checkbox field

Patryk Majecki
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 5, 2024

Hi,

I am trying to use one of the operators '<', '=<', '>', '=>' or something that works similar to them on checkbox field during searching. We use labels that are only numbers and since JQL has reserved characters like "*" or "%" its hard to search for multiple labels (like 20 or more), because writing them all would take a lot of time.

I tried "checkbox ~ 123" but "~" is also not supported. Of course I tried operators mentioned above but they are not supported as well. Is there any option to  replace this operators or to use any mark that would work like "*" or "%" would? This could be very helpful as well since I would be able to create "checkbox in (12*)". 

1 answer

1 vote
Aaron Pavez _ServiceRocket_
Community Champion
January 5, 2024

Hi @Patryk Majecki 

Are you trying to search for value 123 on a checkbox? a checkbox only holds yes or false. It's a boolean.

Here is the list of operators for Jira Cloud:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/

Although it lists all the operators, not all of them work with all the fields.

An easy way to check which operators are available is to let the autocomplete help you.

Here the checkbox allows only these operators:

2024-01-05 10_23_32-Issue navigator - Jira — Mozilla Firefox.jpg

Regards

Aaron

Patryk Majecki
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 6, 2024

Hi Aaron!

At first I would like to thanks you for quick response.

Not exactly 123 it was just an example, lets say we got 10 000 numbers in checkbox and I need to search for all between 2000 and 5000 excluding those between 3005 and 3549. I tried to make it work somehow, but i feel like it is not possible with those operators you mentioned above. Please let me know if there is any way to make it done.

Regards

Patryk

Suggest an answer

Log in or Sign up to answer