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?
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.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot