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

[Patryk Majecki]

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

[Aaron Pavez _ServiceRocket_]

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

[Patryk Majecki]

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