I have to generate a Jira report every day at 12 am, for that I am preparing below JQL queries
I want to get all open issues from 2019-12-09 23:59 if report runs on 2019-12-10 00:00
JQL = project = "RLN" AND status not in ("Closed","Resolved","Done") AND created <= "-1d"
Q1. Can anyone please explain the query?
Q2. how the date calculated if we give -1d
jql = project = "RLN" AND status not in ("Closed","Resolved","Done") AND created <= "2019-12-09 23:59"
Q1. if i use this query i am getting records 2019-12-10 onwards which are not expected results
You can write the query as below to generate the reports for issue created on last day, this can be run at any time on the day
created >= startOfDay(-1d) and created < startOfDay() ORDER BY created DESC
startOfDay() automatically sets the time at 12am for the day
For the case 2#, try using the format as below
created < "2019/12/09 23:59"
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