Usage of operators '' on checkbox field

Question

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*)".

Patryk Majecki · Answer

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

Aaron Pavez _ServiceRocket_ · Answer

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:

Regards

Aaron