An automation rule to update an Issues Date Field with the max date of a field from linked issues

Question

This is in relation to using Jira Product Discovery along with Jira Software Projects.

I have a Jira Product Discovery project called "JPD1" with ideas.

I have Jira Software Project "SP1" with epics & stories.

I would like the automation rule to run that when an epic or story from SP1 is linked to an idea via "Delivery" in JPD1 the due date from the story or epic from SP1 will update the delivery date field on the idea.

For example: I have Idea in JPD1, JPD1-20.

There is already an item from SP1 linked to JPD1-20 with a due date of 11/15/2025. I then add another delivery item from SP1 with a due date of 12/20/2025. The delivery date on JPD1 should update to 12/20/2025.

Then I link an additional issue to JPD1-20 with a due date of 12/1/2025. The rule will run, but not update and keep the 12/20/2025 value.

How can I build an automation rule that will update the field in JPD1-20 with the max due date when issues are related to the idea?

Bonus: automation for when a linked issue from SP1 has its due date updated, when a linked issues link is removed, when a linked issue is cancelled.

Thank you!

Bill Sheboy · Answer

You are getting closer, although there is no need to iterate over the issues with a branch to find / compare dates.  That is where the Lookup Issues action helps.

Let's start with some JQL to find the issues needed.  Assuming your Idea has a key of JPD1-20 and the linked Epic has a key of SP1-30

-- get Idea from implements issues
issue IN linkedIssues("SP1-30", "implements") AND issueType=Idea

-- get issues implementing a specific Idea
issue IN linkedIssues("JPD1-20", "is implemented by") AND issueType!=Idea

-- get child issues of Epic
parent=SP1-30

Please note the link types are directional, such as "implements" versus "is implemented by".  Also note the issues are in different projects, and so any automation rule needs to have multiple-project or global scope to work.

And so when an Epic is linked to an Idea from the "delivery ticket" view, the {{issue}} will be the Epic and the {{destinationIssue}} will be the Idea.

* trigger: issue linked
* smart value condition:* first value: {{destinationIssue.issueType.name}}
* condition: equals
* second value: Idea

* branch: to destination issue* action: lookup issues with JQL of* issue IN linkedIssues("{{issue.key}}", "is implemented by") AND issueType!=Idea

* action: edit issue to set the date to* {{lookupIssues.duedate.max}}

This handles the case when issues are originally linked.  Additional cases will have different triggers, and so need the JQL examples I provided to progressively find issues and update fields.  There are many additional cases, so you will need to decide how accurately you want the field AND when you want it updated.

* when the Idea adds a new linked Epic, update the field
* when the Idea removes a linked Epic, update the field for the remaining ones
* when the due date changes in an Epic linked to an Idea, scan again for updates
* when an Epic is deleted...
* when someone manually changes the date in the Idea...

Evgenii · Answer

Hi, @Steve White

If I understood your question right, this can be achieved by simple comparing of dates.

When new issue is linked, you are just checking, that in linked issue due date is smaller, and updates it. Made basic example, for describing of my logic:

Steve White_16k9qs · Answer

I did some more digging around today and am trying to start it much simpler to be able to build on later as Ive seen that there is some date transformation that needs to be done between Jira Software and Product Discovery projects and some different syntax for referencing delivery items in a Product Discovery project (which ill build up to eventually)

Instead I am just starting out with attempting to update an epic due date to the max date (or keep the date thats already on the epic if it is the max) when a new link is created.

I discovered the difference between [issue in linkedIssues()] which returns relationships like "relates to" and "blocked by" vs [linkedIssue in ()] which returns children and childrens children of the issue as well as the issue itself used in the function.

Hoping Im on the right track any help would be great.