nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to set a scripted field to get a date from another field ?

Aisha M

I need to set up a scripted date field that picks a date from the Due date field.

The scripted date field must pick the most furthest date from that field.

Can someone please help with a script or a similar script that matches this scenario. Thank you

Accepted answers

Antoine Berry

Hi,

What do you mean by "The scripted date field must pick the most furthest date from that field." ?

All comments

Antoine Berry

Hi,

What do you mean by "The scripted date field must pick the most furthest date from that field." ?

Aisha M

@Antoine Berry Thank you for the reply.

So, We want to have a scripted date field in "PROGRAM EPIC" issue type

This scripted field must display the farthest date value from the DUE DATE field available in EPIC (related to the Program Epic)

Example:

EPIC 1 (due date) - 4/9/19

EPIC 2 (due date) - 3/9/19

EPIC 2 (due date) - 1/9/19

PROGRAM EPIC (scripted date field) - 4/9/19

Antoine Berry

Hi,

I am sorry my brain might be a bit slow on monday morning. Could you provide a screenshot ?

I guess you have a custom issue type (program epic), and you are linking epics to it ? And you want to retrieve the farthest date from all these linked epics ?

Aisha M

@Antoine Berry Lol Unfortunately we have the screentshot options disabled for security reasons.

But your understanding is absolutely correct !

Tom _Automation Consultants_

import com.atlassian.jira.issue.link.IssueLink;
import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp

def issueManager = ComponentAccessor.getIssueManager()
def customFieldManager = ComponentAccessor.getCustomFieldManager()

def dueDateField = customFieldManager.getCustomFieldObjectByName("Due Date")

List<IssueLink> linkedIssues = ComponentAccessor.getIssueLinkManager().getInwardLinks(issue.getId())

if(linkedIssues.size() < 1){
return 
}

def farthestDate = new Timestamp(Long.MIN_VALUE)

for(IssueLink iLink : linkedIssues){
     def iLinkIssue = issueManager.getIssueObject(iLink.getId())

     log.error(iLinkIssue.getId())
     Timestamp dueDate = (Timestamp) iLinkIssue.getCustomFieldValue(dueDateField)

     log.error(dueDate)
        if(dueDate.after(farthestDate)){
             farthestDate = dueDate
        } 
}

return farthestDate

You will need to configure your Farthest Date to be a Date Time range picker in the custom field settings page.

Aisha M

@Tom _Automation Consultants_

Thank you so much for the comment !

So, will the script display the farthest day of the Epics linked at the Program Epic (issue type higher than epic) level ?

Tom _Automation Consultants_

@Aisha M

No problem! Yes it will get the inward links of the Program Epic (as long as you put it on the screen for that issue type) which will be various Epics. From there it'll loop over the linked issues (there is no checking that they're of a specific issue type, you can add this in if there will be other issue types linked to this issue) and find the farthest date out of all their due dates.

Let me know if there are any problems!

Aisha M

@Tom _Automation Consultants_ Thank you so so much for helping out !

I did follow all of the steps. But my Program Epic is not showing the farthest date from the due date values in epic. dunno where I m going wrong

Aisha M

@Antoine Berry All the comments seems to have gone

I read your comment through an email notification though But, he insists to have the listener solution as well. Is it possible to simply copy the values and create a listener for "Issue created, and issue updated" events?

Antoine Berry

Hi @Community Manager! Sorry to disturb, but all the comments have disappeared from this question and this one as well. The history is empty... Maybe we have flooded too much ?

Thanks for helping, and sorry if you are not the one I needed to tag.

Aisha M

@Antoine Berry The comments are gone for every post. Even the ones with very limited comments. FYI

Antoine Berry

Oh ok... I checked a few posts but the comments were still there... So it might be a global issue but still linked to specific posts ? Then I probably pinged Erica for nothing, I hope they will come back >_<

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

scripted-field