How to send automatic emails referencing JQL filters results

[romain delobel]

Hello, 

I would like JIRA to send an email to people every week with the results of multiple filters via automation. 

I'm trying to use the lookupissues smart values with the filter's id but it does not work

I'm pretty sure I'm wrong somewhere in the writing but cannot find where

Thanks for your help

[Trudy Claspill · Accepted solution]

Hello @romain delobel 

Welcome to the community. 

Can you show us your entire automation rule please?

Are you getting an error message associated with this automation rule running?

What version of Jira Server/Service Management are you using?

When last I checked "lookupIssues" was not a smart value that was available for self-hosted Jira automation 

[romain delobel]

Hi @Trudy Claspill 

I'm, indeed using a self-hosted JIRA. 

My rule is very basic : 

Also, I'm getting the following error on my audit log : 

That might be linked to the fact that lookupissues is not handled by self-hosted...

Is there a workaround to include filters as smart values in email? 

Thanks again for your time 

[Trudy Claspill]

Use the methodology described here instead:

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

However, I am curious about what you are trying to accomplish. Can you describe your use case and provide the details of your Filter? I am suspicious that this rule may not do what you actually want.

[romain delobel]

Basically, i created several filters to point out missing elements in stories created by my team (story points, description etc....) 

I would like to set up an email automatically sent once a week to specific email addresses to show the results of those filters. 

I would like, if possible, to show multiple filters in one single email

[Boris Berenberg - Modus Create]

You can use our default table template, or make your own based on it in our app, Notification Assistant for Jira to notify recipients of their issues based on a JQL filter as an input.