How can I fetch issues which has been in state In Progress for 30 days, REST API

[Abel Asefa]

I want to know the number of issues which spent a total time of more than 30 days.

For example: If I have issue #1 with the following life cycle,

           Status Changed to in progress : 2017-01-01

           Status Changed to testing : 2017-01-21

           Status Changed to in progress : 2017-01-21

           Status Changed to closed: 2017-01-31

The number of days #1 spent in In progress state is 20 + 10 = 30 days, so this is one of the issues I am interested in.

I want to do a JQL to fetch this issues. CAN THIS BE DONE IN THE REST API ? and How?

Thanks

[Anton Chemlev - Toolstrek -]

Hi!

You can use your constructed JQL in REST API. 

Check this for REST API- https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-example-query-issues and this https://confluence.atlassian.com/jira/tracking-the-time-taken-for-each-workflow-transition-126910724.html?_ga=2.22074299.185577010.1508140336-1545192415.1504782813 for querying Time in status.