Calculate date field based on due date in a linked issue

Question

Hi all,

I would like to create a calculated date field with the misc custom field addon which does the following:

I have 1 Main Issue with a couple of subtasks. The calculated date fields are only relevant in the subtasks.

In the subtasks it is possible to set a dependency to another subtask, this is done via an issue link, link type: 'depends on' (e.g. subtask 1 can only be started after subtask 2 is finished). The calculated date should now calculate the date based on the due date of the linked subtasks + x days (the x days is the value which I have in another custom field).

Is that possible?

Dieter Schade · Answer

I found the time to test the script but even after some adjustments I could not get it to work. Im trying a different script now in a scripted field from the scriptrunner plugin. Nevertheless thank you for your help!

Dieter Schade · Answer

Thank you for the detailed answer! I will try that asap and will update you here if that worked for me.

Best regards

Dieter

David _old account_ · Answer

You can try with a formula derived from the following:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.link.IssueLinkManager;
import com.atlassian.jira.user.ApplicationUser;

IssueLinkManager ilm = ComponentAccessor.getIssueLinkManager();
ApplicationUser curUser = ComponentAccessor.getJiraAuthenticationContext().getUser();
linkedIssues = ilm.getLinkCollection(issue, user, true).getOutwardIssues("Dependency");
if (linkedIssues.size()>0) {
    Issue dependsOn = linkedIssues.iterator().next();
    if (dependsOn.getDueDate()==null)
        return null;
    Long delta = issue.get("my field"); //assuming this is a Number field. Otherwise, needs to be converted to a Long
    Calendar dueDate = Calendar.getInstance();
    dueDate.setTime(dependsOn.getDueDate());
    if (delta)
        dueDate.add(Calendar.DAY_OF_YEAR, delta);
    return dueDate.getTime();
} else
    return null;

You'll need to adapt it to your needs:

* replace the link type name
* possibly replace "getOutwardIssues" with "getInwardIssues" depending on the link direction you're interested in (just experiment until it works)
* replace the field name that contains the number of days to add

For debugging, don't forget to watch atlassian-jira.log for errors. Also, you can use log.error("some text"); to write data to the logs for debugging purposes.