Hi, Is there a way to extract the furthest date from a set of JIRA issues?
Hi @Ted
When you say extract, how are you looking to receive that data?
If you're looking to do it via JQL, the best option is to sort your issues by due date - so for example if you searched for:
duedate is not empty ORDER BY duedate DESC
You'll receive all issues with a due date, ordered from further date at the top to nearest date / previous dates.
If you use this query where some issues with the due date is blank, these will be listed at the top of the results list.
Ste
Thank you, @Ste Wright . Steve. Is there a way to retrieve the top JIRA item from the filter ?
Apologies for delay responding - when you say retrieve the top issue, what do you want to achieve here?
Hi @Ste Wright , for example, if I sort the JIRAs by its due date in descending order, is there a way to pick up the JIRA with the furthest due date?
It looks like you're new here. Sign in or register to get started.