Is it possible to include a static list of JIRA issues in Confluence?

I would like to make a confluence page that only displays the resolved JIRA issues form the previous 7 days. A weekly report if you will. I have a filter in JIRA that shows only resolved issues for the previous week. Using -1w. However if I insert that into Confluence via the JIRA plugin, it will display the previous weeks closed issues relative to when the confluence page is viewed. Do I have to make a seperate filter every week to accomplish this task? Or is there a way to get the JIRA issues into the confluence page, and not have it ever autoupdate again?

1 answer

1 accepted

1 vote
Answer accepted

You need to include absolute dates in the JQL query like "status WAS "Resolved"DURING ("01/01/2010","01/01/2011")".

Btw, you need NOT to create a filter everytime, you can use a dynamic JQL in the URL itself. For example:


And you can get this URL easily from the issue navigator using the permalink icon.

That is really great, than you Renjith. One follow up question I have:

Using the method outlined above we can make a Confluence page that has the issues that were closed for that time period. However, we would also like to include a list of JIRA issues that were "In Progress" for that week. As issues will change over time from In Progress to closed, this report would not be valid if viewed later.

I see that there is a dropdown in the Confluence Jira plugin that goes from Static to Dynamic. Does this make the report static? ie.. will it not query JIRA every time it is viewed?

  • If you need to get In Progress items, then the JQL will be 'status WAS 'In Progress' during ...'
  • AFAIK jiraissues macro queries Jira always whenever the cache period expires.
  • Additionally if you don't need to repeat the job every week, you can use the {run} macro for the users to enter two dates, the start and end dates, and include the jiraissues macro using these variables. By this whenever someone needs the reports, they enter two dates, clicks the button and the query output will be displayed.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

474 views 2 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you