How do I definitively determine when an issue is Accepted (moved to the last column)?

[Randy O_Neal]

OK... so I'm trying to isolate when an issue is transitioned to the last column on my Kanban board via JQL.  The status is Accepted, and I need to establish the date/time when the issue reaches Accepted.  Here's why: I'm trying to capture everything that's been accepted during the last two weeks.  At the moment, I'm using this:

project = [project] AND issuetype in (Bug, Story) AND status IN (Accepted) AND Status changed during (startofDay(-14d) ,endofDay())

Our last issue management system had a specific date - AcceptedDate - which made it easy to determine.  Does the above JQL pass the smell test, or is there a better, more accurate way to accomplish this?

[Trudy Claspill · Accepted solution]

Your JQL looks correct to me.

If you need to absolutely record the date an issue transitions to a specific status then I would recommend that you create a custom field for recording that date/time and set the value using an Automation Rule.

Jira issues have a Resolved date that corresponds to when the Resolution field gets set, but that might not be the same date that the issue changes to your target status. That would depend on your workflow.

[Kelly Arrey]

Alternatively, you could add an "Update Issue Custom Field" post function to the transition to that status.