nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Bill Sheboy

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

All comments

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

Bill Sheboy

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.