Highest ranked custom field value among all linked issues

Use case

This calculated field returns the highest value of a specific custom field among all linked issues.

In this example, the Latest Planned Version is returned. The evaluated versions are stored in another custom field called Planned version.

Create a new Calculated Text Field (by JWT) custom field and name it properly.

Providing a description will help you to identify what the custom field does but this step is optional

Select Advanced text as parsing mode.

Add the following expression:

Text to be parsed for Calculated Text Field:

first(sort(fieldValue(%{issue.cf10409}, linkedIssues()),DESC))

%{issue.cf10409} is the field code for the custom field Planned version (Version Picker (single version)).

To achieve this, the following functions are used:

Add the field to the relevant view screens.

Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.

Check the results

Once configured and added to an issue screen, the result will look like this:

SCREENSHOT

Title	Field type	Label
Check if an issue was resolved on time	Text
Components from all sub-tasks	Text
Details of the last comment	Text	STAFF PICK
Difference between two dates in business days	Text
Display additional details of the issue creator	Text
Display current issue's project category	Text
Display historic due dates	Text
Display reporters of linked Cloud issues	Text
Google Maps location	Text	STAFF PICK
Highest ranked custom field value among all linked issues	Text
Last comment, its author, and timestamp	Text	STAFF PICK
Last commenter's full name	Text
Status and assignee of parent issue	Text

If you still have questions, feel free to refer to our support team.