Jira report on created issues over specific time

[Ludmila Baklanova]

Hello, I need to create weekly report from on e specific project board on issues that's been created from Sun to Sat every week and email it to me. 

Is there a way to use JQL query to get that going and make sure it runs every week to create the report. 

Thank you so much! 

Luda 

[Jack Brickey · Accepted solution]

something like this....

project = abc AND createdDate >= startOfWeek()

set up a subscription to run every Sunday evening just before midnight (depending on your start of week).

[Ludmila Baklanova]

Hey Jack, if project have several boards and I need to run this only on one of them, how do I specify that? 

Thank you!

[Ludmila Baklanova]

knowing that report have to come out every Sunday at 11:59pm covering all created issues from Sunday to Saturday. I believe that jira also have a way to email the report to specific recipients. Is that correct? Thank you, again!!! 

[Jack Brickey]

you create a filter that mirrors the filter of the specific board you are interested in. If this is a classic board go to board settings > general > edit filter. copy the filter and add in the createddate info I shared previously.

the subscription will allow you to define who receives the email. You can also choose to use the saved filter on a dashboard if you want.

[Ludmila Baklanova]

I am not sure I have an ability to copy and create new filter. If I get an access, is that query which you mention would give me all created jira's for a specific week and then set to report on every week after that? Thanks

[Ludmila Baklanova]

would something like that works? 

project = "Cloud Support Engineering" AND createdDate >= startOfWeek(-1) AND createdDate <= startOfWeek(-1)

[Jack Brickey]

i don’t know why you would want/need the second part - cresteddate <=...

[Ludmila Baklanova]

If I need to have report for every week from Sun to Sat, I would not need second part? Cool thanks for navigation. 

[Jack Brickey]

You only need the second part if you run the query well into the next week or beyond, I.e. you are querying outside of the current week.