Is there a way to see if a checkbox option was selected at one time, but is not selected anymore.

Charlie Bolante

I have a checkbox that has options that will be used to flag an issue with a specific property (example, At Risk, High Value, etc) this property can change over time and will be uncheck if they no longer apply, but for reporting purpose we want to be able to tell which issues were flagged a certain way but are no longer flagged. Is this possible?

Andy Heinzer

It's likely not going to be very easy to find this information from Jira itself.  While Jira's JQL does have the WAS operator, this search operator is limited to only working on a few specific system fields like status, resolution, priority, reporter, etc.   It does not work for custom fields like a checkbox field.    So right off the bat, I don't see a way to use the native Jira JQL to search for issues like this.

That said the issue history in Jira will show when users have made changes to an issue, and when field values change.   And if we don't use JQL, we might instead be able to find this information from Jira's SQL database. 

Check out: How to obtain issue change history from database

It provides a bunch of sample SQL queries you could use to try to find issues in Jira that might have once had a custom field value but currently do not.   I hope this helps.

Andy