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 mode mode:

Code Block
languagejs
linenumberstrue
 %{stringToDate(toString(first(sort(fieldValue(% count(fieldValue({issue.cfnnnnn}, linkedIssues())) > 0 ? dateTimeToString( min( fieldValue({issue.cfnnnnn}, linkedIssues())),DESC))), "YYYY-MM-DDTHH:mm:ss"), RUN_AS_LOCAL, RUN_AS_LANG) : null}
UI Text Box

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


Page properties
hiddentrue
Feature

Field type

Smart text field

Parsing mode

General mode

Expression
Code Block
languagejs
linenumberstrue
%{stringToDate(toString(first(sort(fieldValue(% count(fieldValue({issue.cfnnnnn}, linkedIssues())) > 0 ? dateTimeToString( min( fieldValue({issue.cfnnnnn}, linkedIssues())),DESC))), "YYYY-MM-DDTHH:mm:ss")} , RUN_AS_LOCAL, RUN_AS_LANG) : null}
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