How I search for "Closed Date" within JQL or simple search?

Inayat N December 10, 2013

Our users want to filter on the date when issue were closed (Status = Closed). This can be done with SQL, but I don't want to give users database access. Rather let them query from the Issue Navigator. For example, you can search for "Resolved Date" and "Created Date", but I don't see "Closed Date". Any ideas here? Thanks. I recall this being available on older JIRA versions.

1 answer

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 10, 2013

You can capture the date in a custom field. Add a workflow post function in the "Close" transition and capture the current time into a date custom field.

See https://jsutil.atlassian.net/wiki/display/JSUTIL/JIRA+Suite+Utilities+Workflow+Post-Functions#JIRASuiteUtilitiesWorkflowPost-Functions-UpdateIssueCustomFieldPost-Function

Use %%CURRENT_DATETIME%% as mentioned in the docs.

Suggest an answer

Log in or Sign up to answer