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?

[Bob Swift]

I think a Conditioned validator (Update on Transition for JIRA add-on) on the create issue transition could be configured to do this. You need a JQL query to determine the parent key (your definition of parent) and use the result as the first parameter of the fieldValue function substitution variable and Toll Gate as the second parameter. Use that as part of the condition for the creation of the issue.