How to create a Monthly incident report page

[serge calderara]

Dear all,

I have different incident ctaegory which have been raised by product in Jira.

I would like to get a confluence report template which collect a summary of those incident with information like Jira Key, status, owner,... groups by component

That confluence report page should be dynamiquely generated.

1- genrate the proper filter in Jira with necesary fields
2- Call that filter in a conflluence table

Then use the Jira macro in the page

But by doing so is tehre a way to split the result by product from a given filter or should I used a unique filter per component ?

regards

serge 

[Mike Bowen]

Hi @serge calderara 

What do you mean by dynamically generated? 

1. Create the filter in Jira for the incidents. I used the following JQL script: "project = SESD AND issuetype = Incident AND status in (Closed, "In Progress", Resolved) AND created >= "-4w 2d" AND created <= "4w 2d" ORDER BY created DESC"
   
2. Save the filter as something (Monthly incident filter). 
3. Copy the filter code in the URL. 
4. Create a confluence page and use a JIRA filter macro and load the filter saved in step 2 & 3 or type in the filter code. 
5. Update the columns one would like to see. 
   
6. Done. 

Kind regards,

Mike