How do I query history of a custom select field

[Sara Lam]

Hello,

We have a custom select field "Severity Level". We would like to run a filter to see which issue was in Level 1. These issues could have been changed to other levels. It seems only the system fields like "Priority Level" are able to search "Was in". Is it possible for custom select fields and how?

Thank you,

Sara

[Jeison · Accepted solution]

Saralam, I've just filed an improvement request at https://jira.atlassian.com/browse/JRA-34103 to have the ability of using those operators in custom fields as well. Make sure you vote for it to increase its visibility, and feel free to add comments to it.

Hope it helps!

[James Strangeway]

I don't think you can do a history search on custom fields.

[Natalie Hobson]

Correct - the WAS/WAS IN/WAS NOT IN/WAS NOT operators only work with Assignee, Fix Version, Priority, Reporter, Resolution and Status fields only. If there's another way it would have to be through a plugin or custom code.

[Sara Lam]

Thank you for your help. It's too bad we can't search history. It records everything but not searchable. Probably it's better to modify the selection list in "Priority" than creating a custom field in my case.

[Garth Leavey]

I had to get information on the last update of a customfield.  I was hoping there was a builtin JQL query that would work but unfortunately there is not (at this time). To get the history of a custom field I created a SIL Script Custom Field with the following script to get the last update made to a date field:

JFieldChange[] changes = getFieldChanges(key, "customfield_10000");

JFieldChange latestChange = changes[0];
date newest = latestChange.changeDate;

for (JFieldChange change in changes) {
if (change.changeDate > newest) {
latestChange = change;
}
}
return latestChange;

[Joe F. Lee]

This issue is also important to us as we need to be able to run a history search on certain custom fields, which Jira currently does not support.