nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to automate a message to a slack channel with all of the results of a JQL query?

Holly Schomann_lcpysz

For example, I have a filter that provides me a view of all tickets that are in the code in review status for more than 2 days. I would like to automate a slack message to the team channel to include a list of all of those ticket numbers that are provided by the JQL query.

I know how to create an automated message per individual ticket, however I simply want one message to include all of the results of that query.

The slack integration only allows the ability to automate when a trigger occurs, e.g. moved to this status, which is not what I am looking for. Any suggestions?

Accepted answers

Bill Sheboy

Hi @Holly Schomann

You can do this with Automation for Jira, creating a scheduled trigger rule, use Lookup Issues with your JQL search, and send the message to Slack.

Please look here for information to get you started:

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

https://www.atlassian.com/software/jira/automation-template-library/slack-ms-teams

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

Best regards,

Bill

All comments

Bill Sheboy

Hi @Holly Schomann

You can do this with Automation for Jira, creating a scheduled trigger rule, use Lookup Issues with your JQL search, and send the message to Slack.

Please look here for information to get you started:

https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

https://www.atlassian.com/software/jira/automation-template-library/slack-ms-teams

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

Best regards,

Bill

Holly Schomann_lcpysz

thanks so much for responding. Unfortunately, I don't believe that this can help me. I am able to create one message per ticket, but am unable to use this to group mutlple results into one message.

Bill Sheboy

Hi, Holly.

That is where LookupIssue can help. You use it with your JQL, and it treats the results as a set. For example, this would list the keys for them all, which could be sent in one message:

{{#lookupIssues}}
* {{key}}
{{/}}

Please look here to see which fields are available for LookupIssues:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/

Thanks,

Bill

Holly Schomann_lcpysz

Bill, I really appreciate your help, as I am new to automations, can you provide more details to help me get there?

As you can see I have this automation set (for email for testing). Where do i insert the lookup issues? I add this to the description of the email but it still sent individual emails.

Thank you so much for your help. If i could get this done, it would be so helpful for my entire company.

holly

Jira Screen shot.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud