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.

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?

[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

[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

[Trudy 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]

@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

[Vishal Biyani]

@vaibhav bisht 

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

{{#lookupIssues}} {{customfield_10800}} {{/}}

[vaibhav bisht]

[Vishal Biyani]

Can you hit this url and show what value is coming for the custom field corresponding to Company field? This will also confirm that customfield_10800 maps to Company

https://<yourinstanceurl>/rest/api/2/issue/<issuekey>?expand=names

yourinstanceurl would be your datacenter url and <issuekey> should be replaced with your key e.g. CC-1

[vaibhav bisht]

{ "expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations", "id": "11200", "self": "https://support2-jira.devops.test.net/rest/api/2/issue/11200", "key": "CC-1", "fields": { "issuetype": { "self": "https://support2-jira.devops.test.net/rest/api/2/issuetype/10004", "id": "10004", "description": "A problem which impairs or prevents the functions of the product.", "iconUrl": "https://support2-jira.devops.test.net/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype", "name": "Bug", "subtask": false, "avatarId": 10303 }, "timespent": null, "project": { "self": "https://support2-jira.devops.test.net/rest/api/2/project/11000", "id": "11000", "key": "CC", "name": "Company Count", "projectTypeKey": "software", "avatarUrls": { "48x48": "https://support2-jira.devops.test.net/secure/projectavatar?avatarId=10324", "24x24": "https://support2-jira.devops.test.net/secure/projectavatar?size=small&avatarId=10324", "16x16": "https://support2-jira.devops.test.net/secure/projectavatar?size=xsmall&avatarId=10324", "32x32": "https://support2-jira.devops.test.net/secure/projectavatar?size=medium&avatarId=10324" } }, "customfield_11000": 0, "fixVersions": [], "customfield_11001": null, "customfield_10111": null, "customfield_11002": null, "aggregatetimespent": null, "resolution": null, "customfield_11003": null, "customfield_11004": null, "customfield_11005": null, "customfield_10302": [], "customfield_10500": null, "customfield_10303": null, "customfield_10501": null, "customfield_10304": null, "customfield_10700": null, "customfield_10107": "0|i000rr:", "customfield_10305": null, "customfield_10701": null, "customfield_10108": null, "customfield_10306": null, "customfield_10109": null, "customfield_10307": null, "customfield_10901": null, "resolutiondate": null, "workratio": -1, "lastViewed": "2025-03-12T04:13:30.570+0000", "watches": { "self": "https://support2-jira.devops.test.net/rest/api/2/issue/CC-1/watchers", "watchCount": 0, "isWatching": false }, "created": "2025-03-10T06:28:42.433+0000", "priority": { "self": "https://support2-jira.devops.test.net/rest/api/2/priority/4", "iconUrl": "https://support2-jira.devops.test.net/images/icons/priorities/low.svg", "name": "Low", "id": "4" }, "customfield_10100": null, "customfield_10101": null, "customfield_10300": null, "customfield_10102": null, "customfield_10301": null, "labels": [], "customfield_10103": null, "customfield_10610": null, "customfield_10611": null, "timeestimate": null, "aggregatetimeoriginalestimate": null, "versions": [], "issuelinks": [], "assignee": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=dileep.katta@test.com", "name": "dileep.katta@test.com", "key": "JIRAUSER10400", "emailAddress": "dileep.katta@test.com", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=32" }, "displayName": "Dileep", "active": true, "timeZone": "Etc/UTC" }, "updated": "2025-03-12T04:56:22.368+0000", "status": { "self": "https://support2-jira.devops.test.net/rest/api/2/status/10000", "description": "", "iconUrl": "https://support2-jira.devops.test.net/", "name": "To Do", "id": "10000", "statusCategory": { "self": "https://support2-jira.devops.test.net/rest/api/2/statuscategory/2", "id": 2, "key": "new", "colorName": "default", "name": "To Do" } }, "components": [], "timeoriginalestimate": null, "description": null, "timetracking": { }, "archiveddate": null, "customfield_11017": null, "customfield_10600": null, "customfield_11018": null, "customfield_10601": null, "customfield_10602": null, "customfield_10800": "Apple", "attachment": [], "customfield_10603": null, "customfield_10801": null, "aggregatetimeestimate": null, "customfield_10604": null, "customfield_10605": null, "customfield_10606": null, "customfield_10607": null, "customfield_10608": null, "customfield_10609": null, "summary": "Bug1", "creator": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=test", "name": "test", "key": "JIRAUSER10100", "emailAddress": "noreply@domainc.om", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=32" }, "displayName": "supportteam", "active": true, "timeZone": "Asia/Kolkata" }, "subtasks": [], "customfield_11010": null, "reporter": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=test", "name": "test", "key": "JIRAUSER10100", "emailAddress": "noreply@domainc.om", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=32" }, "displayName": "supportteam", "active": true, "timeZone": "Asia/Kolkata" }, "customfield_11011": null, "customfield_10000": "{summaryBean=com.atlassian.jira.plugin.devstatus.rest.SummaryBean@7decc885[summary={pullrequest=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@66283402[overall=PullRequestOverallBean{stateCount=0, state='OPEN', details=PullRequestOverallDetails{openCount=0, mergedCount=0, declinedCount=0}},byInstanceType={}], build=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3c010157[overall=com.atlassian.jira.plugin.devstatus.summary.beans.BuildOverallBean@1baeaaf1[failedBuildCount=0,successfulBuildCount=0,unknownBuildCount=0,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], review=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3e767009[overall=com.atlassian.jira.plugin.devstatus.summary.beans.ReviewsOverallBean@b1fd66e[stateCount=0,state=\u003Cnull\u003E,dueDate=\u003Cnull\u003E,overDue=false,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], deployment-environment=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3f2065e3[overall=com.atlassian.jira.plugin.devstatus.summary.beans.DeploymentOverallBean@51b7b9d4[topEnvironments=[],showProjects=false,successfulCount=0,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], repository=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@5c4c7dd3[overall=com.atlassian.jira.plugin.devstatus.summary.beans.CommitOverallBean@29157c92[count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], branch=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@15261b2e[overall=com.atlassian.jira.plugin.devstatus.summary.beans.BranchOverallBean@79b36947[count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}]},errors=[],configErrors=[]], devSummaryJson={\"cachedValue\":{\"errors\":[],\"configErrors\":[],\"summary\":{\"pullrequest\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"stateCount\":0,\"state\":\"OPEN\",\"details\":{\"openCount\":0,\"mergedCount\":0,\"declinedCount\":0,\"total\":0},\"open\":true},\"byInstanceType\":{}},\"build\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"failedBuildCount\":0,\"successfulBuildCount\":0,\"unknownBuildCount\":0},\"byInstanceType\":{}},\"review\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"stateCount\":0,\"state\":null,\"dueDate\":null,\"overDue\":false,\"completed\":false},\"byInstanceType\":{}},\"deployment-environment\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"topEnvironments\":[],\"showProjects\":false,\"successfulCount\":0},\"byInstanceType\":{}},\"repository\":{\"overall\":{\"count\":0,\"lastUpdated\":null},\"byInstanceType\":{}},\"branch\":{\"overall\":{\"count\":0,\"lastUpdated\":null},\"byInstanceType\":{}}}},\"isStale\":false}}", "customfield_11012": null, "aggregateprogress": { "progress": 0, "total": 0 }, "customfield_11013": null, "customfield_11014": null, "customfield_11015": null, "customfield_10400": null, "customfield_11016": null, "customfield_11006": null, "customfield_11007": null, "environment": null, "customfield_11008": null, "customfield_11009": null, "duedate": null, "progress": { "progress": 0, "total": 0 }, "comment": { "comments": [], "maxResults": 0, "total": 0, "startAt": 0 }, "votes": { "self": "https://support2-jira.devops.test.net/rest/api/2/issue/CC-1/votes", "votes": 0, "hasVoted": false }, "worklog": { "startAt": 0, "maxResults": 20, "total": 0, "worklogs": [] }, "archivedby": null }, "names": { "issuetype": "Issue Type", "timespent": "Time Spent", "project": "Project", "customfield_11000": "Company Distinct Count", "fixVersions": "Fix Version/s", "customfield_11001": "Impact", "customfield_10111": "Team", "customfield_11002": "Change type", "aggregatetimespent": "Σ Time Spent", "resolution": "Resolution", "customfield_11003": "Change risk", "customfield_11004": "Change reason", "customfield_11005": "Change start date", "customfield_10302": "Request participants", "customfield_10500": "Vijay Test889", "customfield_10303": "Customer Request Type", "customfield_10501": "Test777", "customfield_10304": "Organizations", "customfield_10700": "issueFunction", "customfield_10107": "Rank", "customfield_10305": "Satisfaction", "customfield_10701": "Survey RatingRest", "customfield_10108": "Sprint", "customfield_10306": "Satisfaction date", "customfield_10109": "Epic Link", "customfield_10307": "Groups", "customfield_10901": "Target start (Reports)", "resolutiondate": "Resolved", "workratio": "Work Ratio", "lastViewed": "Last Viewed", "watches": "Watchers", "created": "Created", "priority": "Priority", "customfield_10100": "Parent Link", "customfield_10101": "Target start", "customfield_10300": "Linked major incidents", "customfield_10102": "Target end", "customfield_10301": "Approvals", "labels": "Labels", "customfield_10103": "Original story points", "customfield_10610": "Time to resolution", "customfield_10611": "Time to first response", "timeestimate": "Remaining Estimate", "aggregatetimeoriginalestimate": "Σ Original Estimate", "versions": "Affects Version/s", "issuelinks": "Linked Issues", "assignee": "Assignee", "updated": "Updated", "status": "Status", "components": "Component/s", "timeoriginalestimate": "Original Estimate", "description": "Description", "timetracking": "Time Tracking", "archiveddate": "Archived", "customfield_11017": "Time to close after resolution", "customfield_10600": "Program Increment", "customfield_11018": "Time to approve normal change", "customfield_10601": "End date", "customfield_10602": "Baseline start date", "customfield_10800": "Company", "attachment": "Attachment", "customfield_10603": "Baseline end date", "customfield_10801": "rfWorklog", "aggregatetimeestimate": "Σ Remaining Estimate", "customfield_10604": "Task mode", "customfield_10605": "Task progress", "customfield_10606": "Risk consequence", "customfield_10607": "Risk probability", "customfield_10608": "Start date", "customfield_10609": "Approvers", "summary": "Summary", "creator": "Creator", "subtasks": "Sub-Tasks", "customfield_11010": "Operational categorization", "reporter": "Reporter", "customfield_11011": "Change managers", "customfield_10000": "Development", "customfield_11012": "CAB", "aggregateprogress": "Σ Progress", "customfield_11013": "Source", "customfield_11014": "Investigation reason", "customfield_11015": "Root cause", "customfield_10400": "Epic IM", "customfield_11016": "Workaround", "customfield_11006": "Change completion date", "customfield_11007": "Urgency", "environment": "Environment", "customfield_11008": "Pending reason", "customfield_11009": "Product categorization", "duedate": "Due Date", "progress": "Progress", "comment": "Comment", "votes": "Votes", "worklog": "Log Work", "archivedby": "Archiver" } }

[vaibhav bisht]

{ "expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations", "id": "11200", "self": "https://support2-jira.devops.test.net/rest/api/2/issue/11200", "key": "CC-1", "fields": { "issuetype": { "self": "https://support2-jira.devops.test.net/rest/api/2/issuetype/10004", "id": "10004", "description": "A problem which impairs or prevents the functions of the product.", "iconUrl": "https://support2-jira.devops.test.net/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype", "name": "Bug", "subtask": false, "avatarId": 10303 }, "timespent": null, "project": { "self": "https://support2-jira.devops.test.net/rest/api/2/project/11000", "id": "11000", "key": "CC", "name": "Company Count", "projectTypeKey": "software", "avatarUrls": { "48x48": "https://support2-jira.devops.test.net/secure/projectavatar?avatarId=10324", "24x24": "https://support2-jira.devops.test.net/secure/projectavatar?size=small&avatarId=10324", "16x16": "https://support2-jira.devops.test.net/secure/projectavatar?size=xsmall&avatarId=10324", "32x32": "https://support2-jira.devops.test.net/secure/projectavatar?size=medium&avatarId=10324" } }, "customfield_11000": 0, "fixVersions": [], "customfield_11001": null, "customfield_10111": null, "customfield_11002": null, "aggregatetimespent": null, "resolution": null, "customfield_11003": null, "customfield_11004": null, "customfield_11005": null, "customfield_10302": [], "customfield_10500": null, "customfield_10303": null, "customfield_10501": null, "customfield_10304": null, "customfield_10700": null, "customfield_10107": "0|i000rr:", "customfield_10305": null, "customfield_10701": null, "customfield_10108": null, "customfield_10306": null, "customfield_10109": null, "customfield_10307": null, "customfield_10901": null, "resolutiondate": null, "workratio": -1, "lastViewed": "2025-03-12T04:13:30.570+0000", "watches": { "self": "https://support2-jira.devops.test.net/rest/api/2/issue/CC-1/watchers", "watchCount": 0, "isWatching": false }, "created": "2025-03-10T06:28:42.433+0000", "priority": { "self": "https://support2-jira.devops.test.net/rest/api/2/priority/4", "iconUrl": "https://support2-jira.devops.test.net/images/icons/priorities/low.svg", "name": "Low", "id": "4" }, "customfield_10100": null, "customfield_10101": null, "customfield_10300": null, "customfield_10102": null, "customfield_10301": null, "labels": [], "customfield_10103": null, "customfield_10610": null, "customfield_10611": null, "timeestimate": null, "aggregatetimeoriginalestimate": null, "versions": [], "issuelinks": [], "assignee": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=dileep.katta@test.com", "name": "dileep.katta@test.com", "key": "JIRAUSER10400", "emailAddress": "dileep.katta@test.com", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/7b91cd48382578b9e31a96e040ee8c8f?d=mm&s=32" }, "displayName": "Dileep", "active": true, "timeZone": "Etc/UTC" }, "updated": "2025-03-12T04:56:22.368+0000", "status": { "self": "https://support2-jira.devops.test.net/rest/api/2/status/10000", "description": "", "iconUrl": "https://support2-jira.devops.test.net/", "name": "To Do", "id": "10000", "statusCategory": { "self": "https://support2-jira.devops.test.net/rest/api/2/statuscategory/2", "id": 2, "key": "new", "colorName": "default", "name": "To Do" } }, "components": [], "timeoriginalestimate": null, "description": null, "timetracking": { }, "archiveddate": null, "customfield_11017": null, "customfield_10600": null, "customfield_11018": null, "customfield_10601": null, "customfield_10602": null, "customfield_10800": "Apple", "attachment": [], "customfield_10603": null, "customfield_10801": null, "aggregatetimeestimate": null, "customfield_10604": null, "customfield_10605": null, "customfield_10606": null, "customfield_10607": null, "customfield_10608": null, "customfield_10609": null, "summary": "Bug1", "creator": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=test", "name": "test", "key": "JIRAUSER10100", "emailAddress": "noreply@domainc.om", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=32" }, "displayName": "supportteam", "active": true, "timeZone": "Asia/Kolkata" }, "subtasks": [], "customfield_11010": null, "reporter": { "self": "https://support2-jira.devops.test.net/rest/api/2/user?username=test", "name": "test", "key": "JIRAUSER10100", "emailAddress": "noreply@domainc.om", "avatarUrls": { "48x48": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=48", "24x24": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=24", "16x16": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=16", "32x32": "https://www.gravatar.com/avatar/c935db00196b3609ba07e2ec16593fc3?d=mm&s=32" }, "displayName": "supportteam", "active": true, "timeZone": "Asia/Kolkata" }, "customfield_11011": null, "customfield_10000": "{summaryBean=com.atlassian.jira.plugin.devstatus.rest.SummaryBean@7decc885[summary={pullrequest=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@66283402[overall=PullRequestOverallBean{stateCount=0, state='OPEN', details=PullRequestOverallDetails{openCount=0, mergedCount=0, declinedCount=0}},byInstanceType={}], build=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3c010157[overall=com.atlassian.jira.plugin.devstatus.summary.beans.BuildOverallBean@1baeaaf1[failedBuildCount=0,successfulBuildCount=0,unknownBuildCount=0,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], review=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3e767009[overall=com.atlassian.jira.plugin.devstatus.summary.beans.ReviewsOverallBean@b1fd66e[stateCount=0,state=\u003Cnull\u003E,dueDate=\u003Cnull\u003E,overDue=false,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], deployment-environment=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@3f2065e3[overall=com.atlassian.jira.plugin.devstatus.summary.beans.DeploymentOverallBean@51b7b9d4[topEnvironments=[],showProjects=false,successfulCount=0,count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], repository=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@5c4c7dd3[overall=com.atlassian.jira.plugin.devstatus.summary.beans.CommitOverallBean@29157c92[count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}], branch=com.atlassian.jira.plugin.devstatus.rest.SummaryItemBean@15261b2e[overall=com.atlassian.jira.plugin.devstatus.summary.beans.BranchOverallBean@79b36947[count=0,lastUpdated=\u003Cnull\u003E,lastUpdatedTimestamp=\u003Cnull\u003E],byInstanceType={}]},errors=[],configErrors=[]], devSummaryJson={\"cachedValue\":{\"errors\":[],\"configErrors\":[],\"summary\":{\"pullrequest\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"stateCount\":0,\"state\":\"OPEN\",\"details\":{\"openCount\":0,\"mergedCount\":0,\"declinedCount\":0,\"total\":0},\"open\":true},\"byInstanceType\":{}},\"build\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"failedBuildCount\":0,\"successfulBuildCount\":0,\"unknownBuildCount\":0},\"byInstanceType\":{}},\"review\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"stateCount\":0,\"state\":null,\"dueDate\":null,\"overDue\":false,\"completed\":false},\"byInstanceType\":{}},\"deployment-environment\":{\"overall\":{\"count\":0,\"lastUpdated\":null,\"topEnvironments\":[],\"showProjects\":false,\"successfulCount\":0},\"byInstanceType\":{}},\"repository\":{\"overall\":{\"count\":0,\"lastUpdated\":null},\"byInstanceType\":{}},\"branch\":{\"overall\":{\"count\":0,\"lastUpdated\":null},\"byInstanceType\":{}}}},\"isStale\":false}}", "customfield_11012": null, "aggregateprogress": { "progress": 0, "total": 0 }, "customfield_11013": null, "customfield_11014": null, "customfield_11015": null, "customfield_10400": null, "customfield_11016": null, "customfield_11006": null, "customfield_11007": null, "environment": null, "customfield_11008": null, "customfield_11009": null, "duedate": null, "progress": { "progress": 0, "total": 0 }, "comment": { "comments": [], "maxResults": 0, "total": 0, "startAt": 0 }, "votes": { "self": "https://support2-jira.devops.test.net/rest/api/2/issue/CC-1/votes", "votes": 0, "hasVoted": false }, "worklog": { "startAt": 0, "maxResults": 20, "total": 0, "worklogs": [] }, "archivedby": null }, "names": { "issuetype": "Issue Type", "timespent": "Time Spent", "project": "Project", "customfield_11000": "Company Distinct Count", "fixVersions": "Fix Version/s", "customfield_11001": "Impact", "customfield_10111": "Team", "customfield_11002": "Change type", "aggregatetimespent": "Σ Time Spent", "resolution": "Resolution", "customfield_11003": "Change risk", "customfield_11004": "Change reason", "customfield_11005": "Change start date", "customfield_10302": "Request participants", "customfield_10500": "Vijay Test889", "customfield_10303": "Customer Request Type", "customfield_10501": "Test777", "customfield_10304": "Organizations", "customfield_10700": "issueFunction", "customfield_10107": "Rank", "customfield_10305": "Satisfaction", "customfield_10701": "Survey RatingRest", "customfield_10108": "Sprint", "customfield_10306": "Satisfaction date", "customfield_10109": "Epic Link", "customfield_10307": "Groups", "customfield_10901": "Target start (Reports)", "resolutiondate": "Resolved", "workratio": "Work Ratio", "lastViewed": "Last Viewed", "watches": "Watchers", "created": "Created", "priority": "Priority", "customfield_10100": "Parent Link", "customfield_10101": "Target start", "customfield_10300": "Linked major incidents", "customfield_10102": "Target end", "customfield_10301": "Approvals", "labels": "Labels", "customfield_10103": "Original story points", "customfield_10610": "Time to resolution", "customfield_10611": "Time to first response", "timeestimate": "Remaining Estimate", "aggregatetimeoriginalestimate": "Σ Original Estimate", "versions": "Affects Version/s", "issuelinks": "Linked Issues", "assignee": "Assignee", "updated": "Updated", "status": "Status", "components": "Component/s", "timeoriginalestimate": "Original Estimate", "description": "Description", "timetracking": "Time Tracking", "archiveddate": "Archived", "customfield_11017": "Time to close after resolution", "customfield_10600": "Program Increment", "customfield_11018": "Time to approve normal change", "customfield_10601": "End date", "customfield_10602": "Baseline start date", "customfield_10800": "Company", "attachment": "Attachment", "customfield_10603": "Baseline end date", "customfield_10801": "rfWorklog", "aggregatetimeestimate": "Σ Remaining Estimate", "customfield_10604": "Task mode", "customfield_10605": "Task progress", "customfield_10606": "Risk consequence", "customfield_10607": "Risk probability", "customfield_10608": "Start date", "customfield_10609": "Approvers", "summary": "Summary", "creator": "Creator", "subtasks": "Sub-Tasks", "customfield_11010": "Operational categorization", "reporter": "Reporter", "customfield_11011": "Change managers", "customfield_10000": "Development", "customfield_11012": "CAB", "aggregateprogress": "Σ Progress", "customfield_11013": "Source", "customfield_11014": "Investigation reason", "customfield_11015": "Root cause", "customfield_10400": "Epic IM", "customfield_11016": "Workaround", "customfield_11006": "Change completion date", "customfield_11007": "Urgency", "environment": "Environment", "customfield_11008": "Pending reason", "customfield_11009": "Product categorization", "duedate": "Due Date", "progress": "Progress", "comment": "Comment", "votes": "Votes", "worklog": "Log Work", "archivedby": "Archiver" } }

[vaibhav bisht]

Name: Company, Value: Apple

[Vishal Biyani]

customfield_10800 field looks correct with name = Company.

As you are using jql: assignee = {{issue.assignee}} and company is not Empty

if it returns more than 100 rows, it may not work as lookupIssues has a limit of 100.

Add the log message for {{lookupIssues.customfield_10800}} it should show the values.

for the counts try

{{lookupIssues.customfield_10800.distinct.size}}

and see if it works

[vaibhav bisht]

count is less than 20 i would say

somehow automation is not reading customfield_10800 as field or something

[Vishal Biyani]

@vaibhav bisht 

Exploring further as per this documentation link, the lookupIssues in data center may be supporting limited fields. That could be the reason why you are getting an empty value for lookupIssues.customfield_10800 in DC while it works in Cloud.

Jira smart values - issues | Automation for Jira Cloud and Data Center | Atlassian Documentation

[vaibhav bisht]

Maybe issue is with syntax in DC

{{issue.CustomField.id}} in document this syntax is being used to get customField value 

[Vishal Biyani]

No harm in trying it out.

However, issue. will give you access to values for triggerIssue value not the lookupIssues.

[vaibhav bisht]

yes i mean 

{{lookupIssues.CustomField.id}}