Query on JIRA due date

[Ted]

Hi, Is there a way to extract the furthest date from a set of JIRA issues? 

[Ste Wright · Accepted solution]

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

[Ted]

Thank you, @Ste Wright . Steve. Is there a way to retrieve the top JIRA item from the filter ?

[Ste Wright]

Hi @Ted

Apologies for delay responding - when you say retrieve the top issue, what do you want to achieve here?

Ste

[Ted]

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?

[Ste Wright]

Hi @Ted

Aside that it'll be at the top of the list? Are you looking to just have a filter returning one specific issue?

Ste

[Ted]

Hi @Ste Wright , yes, to ruturn the filter-matching JIRA issue with the furthest due date. 

[Ste Wright]

Hi @Ted 

I don't know if that's going to be possible - JQL returns a set of results based on the query, rather than one specific result.

You could return lists of results based on month for example - or perhaps split it into those which are not near their due date, those within 1 week and those which are overdue?

Ste