How long in status

[Lisa Stewart]

I am trying to figure out how long a ticket has been in a certain status. I am sure it is something simple that I am missing..

Here is what I have so far:

project = XXXX ssuetype in standardIssueTypes() AND status in (Open, "In Progress", "On Hold", Intake, New, "HLE Estimate", "HLE Proposed", "HLE Approved", "DLE Estimate", "DLE Proposed", "DLE Approved", "DLE Reviewed", "HLE Reviewed") AND created >= 2021-01-01 AND created <= 2023-02-28 ORDER BY created DESC

Can anyone help me find the time in the current status?

[Jobin Kuruvilla [Adaptavist]]

Another option is to make use of the remote APIs in JIRA. Email integration might be a simpler option as it can be done without much development!