How to extract field value using JQL

Question

We have a JIRA project where in each issue has a "Delivery" date i.e. when this will be done.

Requirement is to find the "maximum Delivery date" amongst the all issues which belongs to the same release. Example:

Issue1 - Release R1 - Delivery Date 15th May 2022
Issue2 - Release R1 - Delivery Date 11th Jun 2022
Issue3 - Release R1 - Delivery Date 25th May 2022
Issue4 - Release R1 - Delivery Date 6th Jun 2022
Issue5 - Release R1 - Delivery Date 17th Jun 2022
Issue6 - Release R1 - Delivery Date 3rd Jun 2022

On our Confluence page, we would like to build a table where in we can show for each release what is the last/max "Delivery Date" i.e.

R1 - Max (Delivery Date amongst all issues which belongs to R1)
R2 - Max (Delivery Date amongst all issues which belongs to R2)
R3 - Max (Delivery Date amongst all issues which belongs to R3)
R4 - ....

Can you please suggest how we can achieve it

Sreenivasaraju P · Accepted Answer

Hi @saket rustagi ,

As per my knowledge, you don't have max or min option in JQL (out of the box).

Alternative for your request is :

* create filter as below

fixVersion = "your release name" ORDER BY "your delivery date field name" DESC

2. Later this filter can be added in the confluence using Jira issue /filter macro and select maximum issues as 1 and columns to display is only your delivery date or fix version and delivery date (as shown below)

I hope this may help.