How do I query on a field that is a Transition Date?

[Ann Barhorst]

If I want to see the time between a Question being raised, and it being Answered.  I would query on the Created Date, but how do I query on the Answered Date?  Need your help.

[Emre Toptancı _OBSS_]

For those interested in this, Time in Status app by OBSS produces reports that show first/last status transition dates for each status. The app also includes reports that show how much time each issues spent in each status, assignee or group; number of times each status or transition was used.

You didn't specify Jira Server or Cloud but Time in Status is available for both(Date reports available only for Jira Cloud for the moment, will be coming soon to server.)

All report data can be exported as XLS, XLSX or CSV.

[Jack Brickey]

if by "answered" you mean resolved then use "resolutiondate". 

[Ann Barhorst]

No, I do not want to use the Resolution Date because the User's often forget to move the JIRA to Resolved or Done.

I want to use the date that the question was moved to Answered.  Any ideas?

[Jack Brickey]

so Answered is a status then?

there isn't a simple JQL function for when an issue transitions from one status into another but there are options.

1. you mention that folks forget to set the resolution or move to Done. If Answered = Done then just get rid of Done or once transition to Answered then use automation to transition to Done. Personally I prefer the former. Unclear why you have two 'done' statuses but there could be a reason.
2. create a date field and set it in post function when moved to Answered. use this custom field in your queries.
3. consider an addon

[Ann Barhorst]

Our workflow allows the Reporter to either "Accept Answer", "Provide feedback" or "Close Issue".  I rather like that there are options.

However even though I can see the transition date on the individual JIRA of when the issue gets Answered, I cannot figure out how to have that data appear in a query result.

[Jack Brickey]

ok got it. makes sense and as you have found your really can't get there natively. You will need an addon, e.g. Scriptrunner or Power Scripts, to name a couple, to capture and record the date when the transition occurs into a date custom field. I don't know of any OOTB solution for this.

[Ann Barhorst]

Thank you for your last response.  Using an addon will help to capture the data going forward, but is there any way to capture the data from the past?  I can clearly see the data, but don't want to have to go through individually to capture the info.  Is there anyway to export this data?