jira - automation email embedded JQL results

[Gavin]

I have a project automation that sends out an email.  I want to include the result of this JQL in the body of the email.  Is there a way to do that?  (Without using filter subscription since I want to format it in a specific manner)

project = MKV AND labels = request AND status != closed

The results of this is 4.  How do I take the result of this and embedded into an email?

email

Ex.  Hello you have 4 issues needing attention.

[Bill Sheboy · Accepted solution]

Hi @Gavin 

For Jira Server/Data Center, the equivalent to Lookup Issues for batch processing is to use a scheduled rule with JQL and the "...process issues in bulk" option.  Then you may use the {{issues}} smart value.

Please look here for more information on that approach:

https://confluence.atlassian.com/automation/bulk-handling-of-issues-993924653.html

Best regards,
Bill

[Boris Berenberg - Atlas Authority]

Hello Gavin,

We support this using the ${issuecount} Placeholder in Notification Assistant for Jira

[KAGITHALA BABU ANVESH]

Hello @Gavin ,

Please add a new action: Lookup issues

I tried the above, but was unable to display all the issues in Email,

I'm only able to show the number of issues only.

[Gavin]

Hmm is this for jira cloud? I think I might have a on prem jira.

[KAGITHALA BABU ANVESH]

for on-premise, I didn't found the smart values in Automation.