JIRAs between 5000 trips and 20000 trips

[Mauricio Caceres]

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:

1. 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]

opay

[Mauricio Caceres]

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?

[Mark Segall]

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.

[Mark Segall]

Hi @Mauricio Caceres and welcome to the community!

Assuming your User Trips field is a numeric field, your existing query could be updated to this:

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" > 5000 AND "User Trips" <= 20000)