Skip to main content
Skip table of contents

History Functions

The history function allows you to view historical field values for Jira fields and use them in formulas. To show the history of a field, use the following format: <fieldName>History

Example:

  • statusHistory → returns a list of all the status changes that have occurred for an issue

History data is currently available for the following fields:

  • Status

  • Story Points

  • Parent

  • Date fields

  • Time estimate fields

  • Custom numeric fields

Narrowing the History

To narrow the history, use the History function along with Array functions.

Example:

  • statusHistory.LAST() → returns the last status the issue was in

Display a Field Value at a Specific Time

The following formula allows you to display the value in a specified field at a specific time.

CODE
WITH  HISTORICAL_VALUE(field, fieldHistory, date) = 
       IF fieldHistory.IS_EMPTY() AND field : field 
       ELSE fieldHistory.FILTER($.time <= date).toText :
HISTORICAL_VALUE(duedate, duedateHistory, datetime("15/May/18 6:24 PM"))

To customize this formula:

  • Replace the duedate and duedateHistory with another field

  • Replace the date and time

For more examples of how the History function can be used, see Sample Formulas - History

History as a Variable

You can also find the history of a field by simply entering “History” as your variable:

  1. Name a variable “History”

  2. In the Source section, select the field you want the history of

  3. Check the Use an array of historical data instead of the current value box

History function - selecting a source.png

If you don’t check Use an array of historical data instead of the current value, Structure will interpret “History” as a standard variable and only return the current value of the Source field.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.