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

Maximiliano Crosa
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!
March 11, 2024

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?

 

4 answers

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.
March 11, 2024

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

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 21, 2024

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

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 12, 2024

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:

start-date-due-date-sum-up.gif

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

0 votes
Guido Scollo March 11, 2024

Hi Maximiliano,

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events