Jql select only highest value

[Mohammad Alolaiwy]

Hi All

I am new user of jira.

I have a custom field with numbers in my issues.

I want to select in jql only the highest number for this field. How to do that please ?

Thanks

[Bill Sheboy · Accepted solution]

Hi @Mohammad Alolaiwy  -- Welcome to the Atlassian Community!

What are you doing with this number?  If you just need the value and do not need it within Jira, you could do this (substituting in your project and field name):

project = myProject AND myNumber IS NOT EMPTY ORDER BY myNumber DESC

The first issue shown will have the highest number.

Best regards,

Bill

[Mohammad Alolaiwy]

I am using it as a custom field for version. Hence i want in my jql queries to select only the latest version. 

[Bill Sheboy]

Thanks for clarifying, and it sounds like you may be able to do this with an automation rule, using a lookup to find the issue with the maximum value and then use that issue's key to do more, as needed.

For example, let's say you wanted to create a version based on that value.  You could have a rule:

• Trigger: some starting condition you want
• Action: lookup issues on JQL noted above with the order by clause
• Branch: with JQL on the key of the issue with the maximum value

key = {{lookupIssues.first.key}}

• Action: create a version using information from the first issue's key {{issue.myNumber}}

If interested, please look here for more information about automation rules:

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

[Щуренко Павло]

Amazing!

Thank you

[Trudy Claspill]

Hello @Mohammad Alolaiwy 

Welcome to the community.

Looking through the documentation on Advance JQL Searching, I do not see a way to do this.

[Mohammad Alolaiwy]

Yes I tried but didn't find anything. Too bad :)