Automated report

[SR]

Hi,

Is it possible to write a script which generates a mail at the beginning of every week and has details on the tickets resolved by an engineer over last week.

Any inputs will be helpful.

Thanks

[Garrett McCreery]

Hi SR, welcome to the community!

These should be the steps you need...

1. Go to the Advanced Issue Search (Filters -> Advanced Issue Search
2. Create your JQL 
   1. resolved > startOfWeek(-1) AND resolved < endOfWeek(-1) ORDER BY resolved ASC
   2. Add the columns you want in the report
3. Save it as a filter
4. After saving, click on Details.
5. Click on New Subscription
6. Set the occurrence of the email to Days Per Week and select Monday.

This will send you an email each week with the data.

[SR]

Thanks for your response .

How to add desired columns in the report ?

[Garrett McCreery]

At the top of the results there is a column drop down that allows you to add/remove columns.

[SR]

ok thanks I could find that. 

But lets say I want to get an email everyday around 9.30 PM with tickets resolved on that particular day from 9am - 9PM (IST)  , how should i formulate the JQL query. 

[Garrett McCreery]

@SR ,

You can use startofDay and endofDay functions with a parameter. Start of day and end of day are 24:00:00 am, and 00:00:00, respectively.

I don't know if there is a way to account for the IST time zone except to figure out the difference between your time zone and IST and then add or subtract hours. If you are in the same timezone then the JQL would look like this:

resolved > startOfDay(9h) AND resolved < endOfDay(-3h) ORDER BY resolved ASC

Adding 9h to the start makes it 9:00am and subtracting 3 hours from the end makes it 9:00 pm.

[Garrett McCreery]

Here is the documentation from Atlassain: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfDay