JIRAs between 5000 trips and 20000 trips

Question

Is there a way to create a JQL query that will show me all the JIRAs that have between 5,000 and 20,000 trips?

I am using this JQL query, but it does not show me the JIRA:

* project = DACT AND (Country ~ Mexico OR Country ~ Colombia OR Country ~ "Dominican Republic" OR Country ~ Peru OR Country ~ Guatemala OR Country ~ Panama OR Country ~ "El Salvador" OR Country ~ Ecuador OR Country ~ Paraguay OR Country ~ Chile OR Country ~ "Puerto Rico" OR Country ~ Argentina OR Country ~ Uruguay OR Country ~ Bolivia OR Country ~ Paraguai OR Country ~ Honduras OR Country ~ Jamaica) AND NOT Country ~ "Costa Rica" AND NOT Country ~ Brazil AND ("User Trips" > 20001 AND "User Trips" < 30000)

Hamza Yakub · Answer

opay

Mark Segall · Answer

You may want to double check the field type.  That field type should support the greater/less than operator if it is configured as a numeric field.  If it supports '~' then it means the field is a short text field and you won't be able to execute that query.

Mauricio Caceres · Answer

Thanks a lot @Mark Segall

Yes, is a numeric field. When i run the query, JIRA show me a notification with the mention that the reference in not supported by JIRA

* The operator '>' is not supported by the 'User Trips' field.
* The operator '<=' is not supported by the 'User Trips' field.

Could there be another way to do the query?