Automation: Custom Fields - Lookup issues not working

Melissa C

Hello,

I've been using Project Automation for some time, I'm able to send emails using the following (See Below) - We recently got a Jira update and now have the "Lookup Issues" when I compile my automation and apply the name smart values (using {{issues}}) I can not get the custom fields. I'm only able to get Key with an url, Summary, Assignee. 

Is this a limitation of the "lookup Issues" feature?

We use Jira Data Center

<tr>
<td>
<a href="{{epic link.url}}">{{epic link.epic name}}</a> </td>
<td>{{Key}} </td>
<td>{{summary}}</td>
<td><a href="{{epic link.Document Link}}">{{epic link.epic name}}</a><br>
</td>
<td>{{customField_11726}}</td>
<td>{{Assignee.displayName}}</td>
<td>{{Teams Impacted}}</td>
<td>{{Product Line}}</td>
<td>{{Updated.shortDate}}</td>
</tr>

Bill Sheboy

Hi @Melissa C 

Unfortunately, the Lookup Issues action for Jira Data Center version does not support most fields yet, including custom fields: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

If it is of any consolation, when Lookup Issues was first added for Jira Cloud, it also only had about a dozen fields, and a year later all of the others were added.  So I recommend watching that suggestion to see any progress.

 

There are two possible workarounds, depending upon what you need to accomplish and your rule structure:

• When you need the fields for a message / email, and are not already using a branch
  • Please try the bulk-handling feature of branches, using the {{issues}} (note that one is plural) in place of {{lookupIssues}}
  • Please look here to learn more: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html
• When you need to sum, average, etc. fields to update another issue
  • Using the Send Web Request action, call a REST API function to search for the issues with JQL, and process the response in place of the lookup results
  • If you want to try that approach, here is a how-to article for calling a REST API function from a rule and the function I believe is needed:
    • https://community.atlassian.com/t5/Jira-Software-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828
    • https://docs.atlassian.com/software/jira/docs/api/REST/9.13.0/#api/2/search-search

Kind regards,
Bill