Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,466,657
Community Members
 
Community Events
176
Community Groups

Reports in confluence or JIRA which is based on date using JQL?

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...

1 comment

Hey Kal,

#3: Here is an article around setting up scheduled Confluence: https://confluence.atlassian.com/doc/scheduled-jobs-96567525.html?_ga=2.58316450.921641210.1513083263-2007992117.1503344444 (references daily reports but may be useful)

#4 You can use this JQL: updated <= startOfDay(-240d) to see what issues have not been updated for 8 months from the current day.

Since you listed #s 1 and 2 as easy I assume you already have solutions for them?  If not would be happy to help with those as well.

Hope this helps,

Tyler

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.

Comment

Log in or Sign up to comment