Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

UI Text Box
sizemedium
typeinfo

Use case

Return the lowest date from a Date Time Picker custom field in the linked issues of the current issue.

Expression

Create and configure a Smart field using this expression in General parsing Jira expression mode:

Code Block
languagejs
linenumberstrue
%{count(fieldValue({issue.cfnnnnn},linkedIssues()))> 0 dateTimeToString(min(fieldValue({issue.cfnnnnn},linkedIssues())),RUN_AS_LOCAL,RUN_AS_LANG):""}let minDate = issue?.links?.map(i=> i?.inwardIssue?.key != issue?.key ? i?.inwardIssue?.customfield_10041 : i?.outwardIssue?.customfield_10041).filter( d => d != null);
minDate.length > 0 ? new Date(minDate.reduce((a, b) => a < b ? a : b )).toString() : ""
UI Text Box

Please, replace nnnnn with the ID of a Date Time Picker custom field.

Used parser functions

Page properties
hiddentrue
Feature

Field type

Smart text field

Parsing mode

General Jira expression

Expression
Code Block
languagejs
linenumberstrue
%{count(fieldValue({issue.cfnnnnn},linkedIssues()))>0?dateTimeToString(min(fieldValue({issue.cfnnnnn},linkedIssues())),RUN_AS_LOCAL,RUN_AS_LANG):""}let minDate = issue?.links?.map(i=> i?.inwardIssue?.key != issue?.key ? i?.inwardIssue?.customfield_10041 : i?.outwardIssue?.customfield_10041).filter( d => d != null);
minDate.length > 0 ? new Date(minDate.reduce((a, b) => a < b ? a : b )).toString() : ""
UI Text Box

Please, replace nnnnn with the ID of a Date Time Picker custom field.

Label
Use case description

Return the lowest date from a Date Time Picker custom field in the linked issues of the current issue.

Complexity

 

Status
titleINTERMEDIATE