Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


How to order a list of issues by a date in the summary or description field?

Ankit Patel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 18, 2023

Such a niche question, but we have a separate release management tool, and irritatingly when you register a release it creates a Jira ticket, then updates the title and the description (with all the dates and info etc, rather than using Jira  fields).

For example, if my release is called "release abc" and my team is "Bananas" and the release date is 1st December 2023, an issue is automatically created and mapped against it in Jira, and the title will be called "Bananas_01_12_release_abc".

how do I create a query which lists all the issues but specifically focuses on "01_12", then order by this? If it helps, there's a consistent description where it says "release date = 01-12-2023". Would be fine if I could order by this description field too, somehow detecting the release date. 

it doesn't populate any specific field like "due date field" or anything like that.

tricky one but any help will be appreciated! Thanks!!

1 answer

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 18, 2023

Hi @Ankit Patel -- Welcome to the Atlassian Community!

This seems an example of the consequences of storing multiple pieces of information in the same field.

With out of the box features of JQL, I believe all you could do is search with the CONTAINS ~ operator if you know the exact release "date" expression.  And even that will not help when there are multiple years (e.g., 2023 and 2024) as the year is missing from the expression.

Ideally, could the release management tool send the entire release date in the summary, description, or better still a custom date field?  If it a complete date value, it could be extracted using an automation rule, placed in a date field, and then used for sorting.

Kind regards,

Suggest an answer

Log in or Sign up to answer