Sending a Filter Result to a Slack Channel Notification

[Pedro Hernandes]

Hi, I just want to send the result to this filter result below (project in (MKT, CEB) AND status in (ADJUST, Assigned, "Content Value Feedback", Editing, "Final Review for Publishing", "IDEAS | BACKLOG", "In Progress", REVIEW, "Ready to publish", "To Be Assigned", "To Do") AND assignee in (5f0cec379d9a120029406004) AND due <= 7d ORDER BY due ASC, created DESC) in a Slack Channel Notification in a weekly basis. How to?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Pedro Hernandes

Filter subscription currently works for individual users and groups. You could use most likely an automation, with webhook to send results to a slack channel. This automation would use a scheduled trigger, to manage the weekly sent.

Let me know if that helps.

Alex

[Pedro Hernandes]

Yep, I have an individual subscription, and did try with the webhook, but it's not working:

[Alex Koxaras _Relational_]

The rule you have created will run only for the issues that have changed since the last time that rule executed.

What I would do, for testing purposes, is to:

• Change the trigger to manual
• Remove the "only include issues that....", just to make sure that I will receive results
• Run manually the rule
• See if I receive any messages on slack

Click as well "validate query" to see if you are getting any results.

Let me know how this will go.

[Bill Sheboy]

Hi @Pedro Hernandes 

Adding on to what Alex suggests and your automation rule image:

As implemented with the scheduled trigger with JQL, this will post a message for each issue found.  If you would prefer one message with the list of issues, consider using:

• a scheduled trigger with no JQL
• the LookupIssues action with your JQL
• a condition to check if there are any issues to send {{lookupIssues.size|0}} is greater than 0
• and then send the message with the list of issues

Best regards,
Bill

[Pedro Hernandes]

It validates, but doesn't send these 3:

@Bill Sheboy I add it, but it doesn't seem right (because it didn't work of course), where and how should I do this?

[Alex Koxaras _Relational_]

• In the lookup component, use the filter= "weekly planning".
• Add a advance condition, as @Bill Sheboy stated with {{lookupIssues.size|0}} is greater than 0
• On the Send Slack component write something like:

Hey team - we've got the following issues left in this sprint:
{{#lookupIssues}}
* {{key}}
{{/}}

 Test the rule again

[Pedro Hernandes]

Am I missing something?

[Alex Koxaras _Relational_]

Hmmm...I'm getting correct results:

The only difference I see is that I have checked the box "send message as automation user". Try adding this and try again.

[Bill Sheboy]

Hi @Pedro Hernandes 

If that does not fix it with the suggestion from @Alex Koxaras _Relational_ please try this:

• after the action for LookupIssues, add an action to write to the audit log with the number of issues returned:

Number of issues returned = {{lookupIssues.size|0}}

• post an image of your audit log from trying to run the scheduled rule manually.  That may reveal what is happening; I suspect your filter is not running as expected.

Thanks!

[Pedro Hernandes]

Nope, still blank, here are the logs:

[Alex Koxaras _Relational_]

@Pedro Hernandes first of all, your JQL is wrong. You might have saved it with a different name. So carefully go back and check the correct name.

When you will enter the correct JQL, and you will click "validate query", it will return something (even 0 results).

Make that change and let me know

Alex