Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jql select only highest value

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

2 answers

Hello @ALOLAIWY 

Welcome to the community.

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

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

Hi @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

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

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

80 views 2 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you