Searching for a number range within the Summary or Description field

[Nathan Wong]

Is it possible in JQL to search for a number range? 

For example: 

If a submitted ticket contains a number between 500,000-900,000 in either the summary or description field, assign it to random agent. 

I've tried doing the simple version 

description  ~ >= 500000  

But obviously won't work like that. 

Is there a way to maybe run a script? 

[Thomas Deiler · Accepted solution]

Dear @Nathan Wong ,

unfortunately not possible from out-of-the-box. To analyse a text field for numbers and then validate the value is complex and not possible by a JQL.

I would do this with a script from outside - the API.

• Search for issue, eg the last 24h
• parse all subjects for the number range
• if true, set a flag or ad a new label in those issue

Then within Jira, you can JQL filter for that label.

So long

Thomas