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
Community Members
Community Events
Community Groups

Automated report


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.



1 answer

0 votes

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.

Thanks for your response .

How to add desired columns in the report ?

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

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. 

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

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you