How to reflect in JQL a range (1-50) from custom field.

[Alex Shirokov]

Hi Gurus! 

I need to create a filter that will show issues that have a value in the custom field (Ranking) from 1-50. 

Thank you in advance

[JM Perrot · Accepted solution]

Hello @Alex Shirokov 

Did you try something like that ?

"Name_of_customfield[Number]" >= 1 AND "Name_of_customfield[Number]"<=50 ?

If Ranking is the name of your field :

"Ranking[Number]" <= 50 AND "Ranking[Number]" >= 1

[Alex Shirokov]

Thank you very much! 

I do not know why I tried the some script and it did not work for me. 

Now it is working like a charm! 

[Manoj Gangwar · Accepted solution]

Hi @Alex Shirokov ,

you may try something like this-

project = "My Project" and "Rank Number" >= 1 and "Rank Number" <= 50

[Alex Shirokov]

Thank you, Manoj, 

As I wrote above it did not work for me before but now works fine. I presume I screwed on something.