How to update Project Start Date and Due date according to Epic earliest start date

Petar Cvetanovic
Contributor
July 10, 2024

Trigger:
When the Project issue type is transitioned to status DONE

Action:
Edit the Project Start Date and Due Date according to the earliest start date and last end date of the Epic. 
The link type is custom, also. It is called Timeline


More detailed info, see video - 

https://www.loom.com/share/ed85a3b4a0a44008a29a8909399d4bfc

2 answers

1 accepted

1 vote
Answer accepted
Marc - Devoteam
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.
July 10, 2024

Hi @Petar Cvetanovic 

It might be as simple to use "issueLinkType = Timeline" in the lookup action.

Would that help you further.

This as I see you use linked issues and not Jira Plans hierarchy, then you would be able to use the "Parent" field.

The parent field always was in the system in Jira Plans (Jira Advanced Roadmap) is available.

The field Epic Link has been migrated to this Parent field as well. Epic Link has been depricated

Petar Cvetanovic
Contributor
July 10, 2024


Not working unfortunately :(

Petar Cvetanovic
Contributor
July 10, 2024

Screenshot 2024-07-10 at 14.08.18.png

Marc - Devoteam
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.
July 10, 2024

Hi @Petar Cvetanovic 

Can you provide me the JQL in the lookup, according to the error in the log it seems not to be correct.

What are the in- and outbound references fro the link Type Timeline, are they timeline for both or do they differ?

Marc - Devoteam
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.
July 10, 2024

If I look at it again:

JQL could be: type = Epic and LinkType = Timeline and "Start Date" is not empty.

There is no need for smart value trigger issue in the lookup in my opinion.

Petar Cvetanovic
Contributor
July 10, 2024

"issueLinkType = Timeline" = {{triggerIssue.key}} and "Start Date" is not empty

video explanation  - https://www.loom.com/share/e83c3187c7a54ba8ad2dac52f8de3257

Marc - Devoteam
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.
July 10, 2024

Hi @Petar Cvetanovic 

I just replied before you.

JQL could be: type = Epic and LinkType = Timeline and "Start Date" is not empty

Or another option key = {{trigger.issue}} and LinkType = Timeline and "Start Date" is not empty

Petar Cvetanovic
Contributor
July 10, 2024

Not working. Can you send me a SS how the whole should look like?


This is what i got

Screenshot 2024-07-10 at 15.16.05.png

Marc - Devoteam
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.
July 10, 2024

Hi @Petar Cvetanovic 

Replace LinkType with issueLinkType.

LinkType is an option from an app on my instance.

Petar Cvetanovic
Contributor
July 10, 2024

Ok

  • Next step is to lookup only issues that are related to transitioned project not all of them
  • Query finds 5080 ticket

Screenshot 2024-07-10 at 15.51.43.png

Marc - Devoteam
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.
July 10, 2024

Hi @Petar Cvetanovic 

Then try the other JQL I provided:

key = {{triggerissue.key}} and issueLinkType = Timeline and "Start Date" is not empty

 

Like John Funk likes this
Petar Cvetanovic
Contributor
July 11, 2024

Still not working 

 

Screenshot 2024-07-11 at 10.13.14.pngScreenshot 2024-07-11 at 10.13.37.png

Like John Funk likes this
Marc - Devoteam
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.
July 11, 2024

Hi @Petar Cvetanovic 

Complete other option.

Before the lookup, create a variable. Give the variable a name and use as smart value {{triggerIssue.key}}

Then in your lookup perform the JQL as follows:

issueLink = {{variable-name}} and issueLinkType = Timeline and "Start Date" is not empty

Add a log action to log the result of the lookup, log action should contain only: {{lookupIssues}}

This should present the linked issue keys.

The do the edit 

Like John Funk likes this
Petar Cvetanovic
Contributor
July 12, 2024

Working thank you for the support !!!! 

Like Marc - Devoteam likes this
0 votes
Dave Mathijs
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 10, 2024

Hi @Petar Cvetanovic I wouldn't be able to immediately answer your question, but I just wanted to say that I love the fact that you made a Loom video to provide context to your question, well done!

Petar Cvetanovic
Contributor
July 10, 2024

Thanks. I would really appreciate the help

Like Dave Mathijs likes this

Suggest an answer

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

Atlassian Community Events