Get the min and max dates of the child issues of a task

[Maximiliano Crosa]

Hi all,

I need to get the JQL to determine the minimum start_date and the maximum due_date of all the child issues of a give task.

Can you help me with this?

[Bill Sheboy]

Hi @Maximiliano Crosa -- Welcome to the Atlassian Community!

First thing, what problem are you trying to solve by doing this?  What will you do with the min and max once you have them?  Knowing that may help the community to offer better suggestions.  Thanks!

Until we know that...

Out-of-the-box JQL cannot find things like min, max, etc. for a set of issues.  It is not an actual SQL, but instead a tool to help find issues for boards, reporting, etc.

Some possible work-arounds you could:

• create a JQL filter, ordered by the date field, and examine the first / last value in the results
• investigate marketplace addons to JQL which add functions such as this
• investigate marketplace addons for reporting which can do min / max checks
• use an automation rule to find the values, assuming there are fewer than 100 issues

Kind regards,
Bill

[John Funk]

Hey @Maximiliano Crosa  - How are you coming with this?

[Hannes Obweger - JXL for Jira]

Hi @Maximiliano Crosa

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports - you can also e.g. group your issues by any issue field(s), configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes

[Guido Scollo]

Hi Maximiliano,

you cannot use JQL to obtain minimum and maximum values from field issues.