how to get jira stories, bugs modified or updated on a particular date

[Sandeep]

When I give created = "2015/09/02" or updated = "2015/09/02" in a filter query, it does not result in any data. But there are bugs which have been either created or modified on this date.

[Jobin Kuruvilla [Adaptavist]]

Giving the exact date will not help as it indicates 12:00AM in the morning. Try giving the period:

created >= "2015/09/02" and created < "2015/09/03" (i.e. next day, depends on your day format).

You can also use functions like startOfDay() and endOfDay().

[Nick]

Minor detail, do not forget "updated" (created >= "2015/09/02" and created < "2015/09/03") or (updated >= "2015/09/02" and updated < "2015/09/03")

[Sandeep]

Thanks Jobin & Nick. It worked for me. I would also like to know how to get the status of bugs at a point in time. For eg. the status of bugs for 09/03/2015 is Open/Reopened: 30 Resolved: 25 Closed: 45 In Progress: 2 How do I get the status as of 09/01/2015? Thanks Sandeep

[Jobin Kuruvilla [Adaptavist]]

You can't do this with searching. Searching returns the current state. But you can search based on history of status. For example, status changed from xyz to abc after -10d by jobin And so on..

[Sandeep]

Thanks Jobin, will try it.