How do I have a daily report of a specific filter?

[Armando Calvache]

Hi!

I would like to have a daily email with the list of issues of a specific filter in jira automation.

I am using the lookup issues but I am not sure if I am writing the correct way the filter I want.

[Vishal Biyani]

@Armando Calvache 

Have you given view permission to the filter? if it is private then automation will give error

[Armando Calvache]

@Vishal Biyani Yes, it is visible to anyone in my organisation

[Vishal Biyani]

please share the SS of your audit log to understand what error message you are getting

[Armando Calvache]

I didn't know that existed. Seeing what appears here, it seems that it doesn't find the filter well. Any advice?

[Vishal Biyani]

@Armando Calvache 

i suspect you have issue due to filter permission. Can you check what is the view permission and confirm?

[Armando Calvache]

The filter is set so that anyone in my organisation can see it, should I pay attention to any other settings?

[Vishal Biyani]

if you have confirmed that permission for the filter looks like 

 

Then to debug, can you run the filter in jql and check how many issues are returned?

[Vishal Biyani]

@Armando Calvache 

To better format the email given that there could be multiple issues, you can format your email with html table like this

<table border="1" style="border-collapse: collapse; width: 100%;>
<thead>
<tr>
<th style="text-align: left; vertical-align: top;">Issue Key</th>
<th style="text-align: left; vertical-align: top;">Summary</th>
</tr>
</thead>
<tbody>
{{#lookupIssues}}
<tr>
<td style="text-align: left;">{{key}}</td>
<td style="text-align: left;">{{summary}}</td>
</tr>
{{/}}
</tbody>
</table>

[Armando Calvache]

@Vishal Biyani Thanks! I guess it will help for sure once I fix the problem of not showing the issues

[Dmitry Astapkovich _Colined_]

Have you tried adding a subscription to a filter? 

[Armando Calvache]

Yes, but I want to send that info to another user, not only for me

[Dmitry Astapkovich _Colined_]

You change the subscription from Personal to Group:

[Armando Calvache]

Understood, and is it possible to customise the columns displayed?

[Dick]

Hi @Armando Calvache Welcome to the Atlassian Community

Please share what you have so far (pictures of your automation), then we can help expanding on that to cover your question.

You're aiming for a scheduled trigger (cron based), a suitable lookup issues jql and an email action with proper list-iteration with smart values representing the stuff you want to be put into the email.

Kind regards,

Dick

[Armando Calvache]

I leave them attached. As you can see, the automation is composed of three blocks. The periodicity block, the filter block (the number 10395 is the ID of the desired filter) and the mail block where I have two options written.

[Dick]

Hi @Armando Calvache 

Thanks for sharing, but the syntax you use in the email is incorrect. Correct syntax:

• {{#lookupIssues}} {{key}} {{/}}
  is the standard where you get a complete list of keys.
• {{#lookupIssues}}{{key}} - {{summary}} - {{status}} - {{url}}{{^last}},{{/}}{{/}}
  if you want the key - summary - status - url combined values separated by commas.

Reference for this: Atlassian smart values page

Kind regards,

Dick

[Armando Calvache]

It doesn't work when I type that. Do you know if the fact that nothing is printed in the mail is due to an error in the lookup issues block?