Automate Back Log Issue Report

[Cyril James]

Team, on a weekly basis, I want to pull the list of stories in the backlog, sort by created date old to new, and send to a Product Owner automatically.  I do this manually today, creating a filter, exporting it, attaching to an email and sending.

A bonus would be to automatically send via MS Teams.

Thank you!

[Mark Segall]

Hi @Cyril James - You can go about this a couple ways:

Filter with subscription

Create a filter and add the product owner as a subscriber.  This will provide an emailed tabular view of the issues each week

Automation

NOTE - If you have a lot of issues, this rule may throttle on you:

• TRIGGER: Scheduled (Weekly)
  Uncheck the JQL
• ACTION: Lookup Issues
  • Your JQL
• CONDITION: (Advanced)
  • {{lookupIssues.size}}
    Greater Than
    0
• ACTION: Send Teams Message
  

  • {{#lookupIssues}}
    * {{key}} {{summary}}
    {{/}}

[Cyril James]

Thanks again @Mark Segall I will give it a go!

[Mark Segall]

Note - the automation rule will cap at 100 issues