CODEWITHSUNDEEP
jira
Daniel Newman
Daniel Newman

Reputation: 220

How do I view or query an issue's original due date in JIRA?

In JIRA, due dates can be updated regularly as project milestones change. While this is useful functionality, sometimes it would be useful to be able to compare the originally-entered due date to the issue's current due date.

This information is retained in the Change History database table, but when I try to use the JQL history query functionality provided in JIRA 5.0, JIRA returns an error message "History searches do not support the 'duedate' field."

At this point, I'm feeling stuck. Is there any way (short of writing a custom plugin or manually parsing the database) to extract this useful data?

Upvotes: 2

Views: 2493

Answers (1)

Kuf
Kuf

Reputation: 17828

You could use the JIRA Behaviours Plugin save the original date in custom field, using something like:

FormField due_date = getFieldByName("Due Date")
FormField orig_due_date= getFieldByName("Original Due Date")

if (orig_due_date.getFormValue() == '') {
 orig_due_date.setFormValue(due_date)
}

By saving the date to custom field you will be able to use the JQL to find and sort issues based on their original due date.

Upvotes: 1

Related Questions