You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Hi,
We would like to set up a quarterly report in Confluence or JIRA, which will allow us to do the following:
1. Create a list of existing issues in a projects - easy
2. Sort them by last modified date - easy
3. Send out a report every quarter to a user - not sure how confluence would do a scheduled report job/email?
4. Highlight any issues which haven't been updated for over 8 months
Ideally we'd like to do this without plugins wherever possible. If we cannot get confluence/JIRA to generate a quarterly report and send it out, it would be OK to have it in Confluence for example, but compare "last modified date" with "today's date", and if that is more than 8 months, then it gets highlighted somehow...
Tyler,
Thank you very much. The first two should be covered by using a JQL query with ORDER BY and using that in a confluence macro to generate the report. Unfortunately, I'm not sure if the scheduling job you referenced in your link (which I did have a look at prior to posting) will do the job (no pun intended!). But I will look into it in further detail! It's not a deal breaker as we can request the person to check that site every quarter, at which point it won't be too bad.
The latter part of your response is spot on! I'll include that in the JQL query such that the report generates that based on the day comparison.
Thank you very much for your effort in responding to that.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events