Can we automate the issues from Jira to publish live reports in cluence using macros?

[kanwaljeet singh]

Can we automate the issues from Jira to publish live reports in Confluence using macros?

If yes, please share some material to learn about those items.

[Arkadiusz Wroblewski]

Hello @kanwaljeet singh 

Yes on Cloud you can show live Jira reports in Confluence with macros. And in most cases you don’t need automation at all. The macros pull the latest data from Jira when someone opens (or refreshes) the Confluence page.

What to use:

Jira Issues / Jira work items macro → shows a live table/list based on JQL or a saved filter

https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-issues-macro/

Jira Chart macro → shows live charts (pie, stats, created vs resolved, etc.) from JQL/filter

https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-chart-macro/

When automation makes sense:

Only if you want Jira to create a Confluence report page automatically (weekly report pages, one page per release, etc.). The “live” part still comes from the macros.

https://support.atlassian.com/cloud-automation/docs/use-jira-automation-with-confluence/

How to do it : Edit the Confluence page → type / → search Jira → add the macro → paste your JQL (or select a filter) → publish.

Have a great Day 🤠 ☀️ 

[Chris Rainey]

Hi there,

Could you share more information around your desired process flow? If this were an automation, what would you expect this to look like? 

Getting understanding around that expectation can help answer the question of what's possible or not.