Hi, I'm facing issue while replicating one Jira automation in Data Center instance which is working fine in Cloud. Here lookupIssues function is not returning correct value instead giving 0 count as an output. Please refer to below screenshot. Rule is to get distinct count of "Company" custom field and assign that count to another numbered custom field "Company Distinct Count". Also let me know does DC instance Jira automation rules support fetching distinct count for any customField?

yes i mean {{lookupIssues.CustomField.id}}

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; } } }

lookupIssues function not returning correct value instead giving 0 count as an output

vaibhav bisht

Hi,

I'm facing issue while replicating one Jira automation in Data Center instance which is working fine in Cloud.

Here lookupIssues function is not returning correct value instead giving 0 count as an output. Please refer to below screenshot.

Screenshot 2025-03-12 at 9.06.43 AM.png Screenshot 2025-03-12 at 9.11.18 AM.png

Rule is to get distinct count of "Company" custom field and assign that count to another numbered custom field "Company Distinct Count".

Also let me know does DC instance Jira automation rules support fetching distinct count for any customField?

Accepted answers

All comments

Vishal Biyani_2pr07j

@vaibhav bisht

Below article mentions the JIRA Datacenter versions on which automation works

We're bringing the Lookup Issues and Create Variable actions to Automation for Jira Data Center

What is the version of jira data center that you have?

vaibhav bisht

its jira 9.12.0

Also while troubleshooting i came to know that issue is not with distinct or size functionality but somehow automation is not reading "customfield_10800" which is of text-type

Trudy P Claspill

Hello @vaibhav bisht

Welcome to the Atlassian community.

What type of field is Company?

Are you trying to get the count of values in the field for each issue and add that to the number field? Example: the issue you show has on value in the Company field so 1 would be entered in the number field.

Or are you trying to get the count of unique values in the Company field for all issues found by the Lookup and record that number in all the issues found?

Also please provide screen images that show your entire rule. What you have shared doesn't show a step where you are trying to set the number field.

EDIT/ADDITION:

In Cloud is the Company field also a text field?

Are you sure you have the correct custom field ID for the field.

Vishal Biyani_2pr07j

@vaibhav bisht

After your call to lookup, can you add a log statement, to see what values you are getting in the field.

vaibhav bisht

Screenshot 2025-03-12 at 10.31.58 AM.png

Dick

Hi @vaibhav bisht , Welcome to the Atlassian Community

To my best knowledge (and documented on the Atlassian smart values page), lookupissues only support a limited set of properties;

key, description, url, summary, assignee.displayname, reporter.displayname, status.name, issuetype.name, resolution.name, fixVersions.name, created, updated, project.name and story points.

You cannot use custom fields.

Kind regards,

Dick

Bill Sheboy

Hi @vaibhav bisht -- Welcome to the Atlassian Community!

As others have noted, the Lookup Issues action for Data Center automation does not support custom fields yet. Here is the suggestion to add that capability: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

There are two possible workarounds, which are described here: https://community.atlassian.com/forums/Jira-articles/How-Can-I-Sum-Up-Multiple-Issues-into-a-Parent-Number-Field/ba-p/2882712#M16701

Kind regards,
Bill

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-server