How to get the Timetaken for moving the STATUS from OPEN to inprogress

Sunilbaba Villuri August 12, 2017

Hi All,

  i want to PULL timetaken for moving a ticket from status open to inprogress using JQL command. i can command for STATUS FROM "open" TO "In Progress" but i was unable to get the timespend during the transition.

 

could you please help with JQL Command

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 12, 2017

JQL is not SQL.  It finds issues that match criteria.  It has nothing to say about the data on those issues.

You will need to push the search results through a report that pulls out the data you want to see.

Sunilbaba Villuri August 12, 2017

Hi Nic,

 i have this jira service api endpoint : rest/api/2/search?fields=*all . But i was unable to find the fields for STATUS to calculate time from open to inprogress

 

 is there any way ?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events