Find time with Field Value

Christian_b1x1yy

We have a check box field that rotates between being checked and unchecked, depending on how it's being worked on. I am wondering if there is a way, even through an app, where I can easily get a report of the amount of time that box was checked. I would love to be able to get the historical data on it, but even a solution that would work moving forward would be helpful.

All the best,

Christian 

Bill Sheboy

Hi @Christian 

Short answer: maybe.

Depending on the type of checkbox field (i.e., built-in type or marketplace addon), the information about changes to the field may be in the issue history.  If so, one could write code to read the issue history to examine the changes over time, and calculate the duration.

Also, if changes to the field are detected by Jira as a field update, one could use a Jira Automation rule to save the date / time when the field was checked in a custom field (or entity property).  The same rule could then detect the unchecked condition to stop the clock and record the duration, such as in another custom field, comment, etc.

If you are using a marketplace addon / app for the checkbox, you may want to contact the vendor to learn if they have such measurement capabilities built-in.

Kind regards,
Bill