How do I get issues that have had a certain status within a certain period?

[Jannik Luyten]

I've seen there is a new feature, issue status history, but I need more than this. I need to get all the issues of a project that had one or more statuses in a certain period. The JQL query "status was in (Open, Closed)" doesn't take a date into account and the available date fields are for the current status of the issue.

Is it possible to get all issues that had a certain status in a certain period? I have access to the SoapService of JIRA, so I can go via this way as well, although I haven't found a method that gives me back the workflow or something like that to do what I want.

Kind regards

Jannik

[Tom Moors · Accepted solution]

This is possible since Jira 4.4 with the addition of JQL functionality:

PROJECT = "Project Name" AND (STATUS WAS "Closed" AFTER "date1") AND (STATUS WAS "Closed" BEFORE "date2")

To add this possibility to older versions, it is possible to write a JQL function, workaround with customfields or install other plugins.

[Renjith Pillai]

It is possible by having custom date fields which gets updated as Post action during the transistions. Byt doing this the date of change of state gets stored in these custom fields and you can run a filter (or jql) on the same.

(For doing the post action for workflows, you need to have Jira Misc Workflow Extensions

https://plugins.atlassian.com/plugin/details/292

Additionally, in the post action, this action 'copy from one custom field to another' should be at the last and the the source field will be 'Updated'.

[Jannik Luyten]

Thank you for the respons Renjith V. So it isn't possible without installing an extention?

[Renjith Pillai]

I think, unfortunately no, and I would say, you will like this custom fields since, within the issue itself, while viewing you can clearly see the dates in which issues have moved to different states.

Also this plugin is quite useful with many other post functions and most Jira installations has this installed.