Automated report

Question

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 · Answer

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

Garrett McCreery · Answer

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

SR_kh0yqr · Answer

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.