Combine two filter subscription in one email

[Vignesh Jayagopal]

Hi,

I have two filters for my project with different logics and have a subscription email sent to customer every week.

Now customer want to see both the filter results in single email with two sections in it for each filter results.

Please let me know if this is feasible or any other way to implement this.

[Nic Brough -Adaptavist- · Accepted solution]

No, there's no way to do this as described.  Each filter is stored separately, and the subscription function only holds one pointer to a filter to run against.

Manually, you could take the two filter definitions and merge them into a third, then get people to subscribe to that, but that would not give you sections (closest you could get is some form of flag to say why an issue was selected and sort by it)

[Bill Sheboy]

Hi @Vignesh Jayagopal 

One way to do this with built-in Jira features is with a scheduled automation rule in a project, although it could get a bit more complicated if you need many of the issue fields.

If you only need a few details, you could use the LookupIssues action with JQL, gather the results in a created variable, and repeat for the other JQL.  Then bundle the results into your email.

When you need more issue details than LookupIssues can provide, you would need a webrequest to call the REST API for your JQL to gather all the fields, parse them from the response, and then build the email from the results using text and list functions.

As another alternative, you could investigate the marketplace to purchase other reporting options.

Best regards,
Bill