Jira query to return issue status in a specific date using resolution date

[tal yaakov]

Hello,

I am trying to run a query using a resolution date and retrieve a list of results with the actual status according to the resolution date.

When running this query today, I receive a list with the resolved bugs while I would like to know if they were open during this period of time.

In my case, if the bug was "open" on the 01-01-2017, I'd like to get it in the response even though it is closed now.

Thanks! 

[Piotr Bojko]

Could you provide an example?

Smart QL - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview can query historical issue changes in some advanced ways.