You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

This function returns the timestamps of when a text field has changed satisfying a certain condition.

Syntax
fieldChangeTimes(textField, condition) #Output: Number list
Examples
Parser expressionDescription
fieldChangeTimes(%{issue.summary}, ^0% !~~ "IMPORTANT" AND ^1% ~~ "IMPORTANT")
This example returns the list of timestamps of when the word "IMPORTANT" has been added to the current issue's summary ignoring the case.
fieldChangeTimes(%{issue.priority}, ^0% not in ["Critical", "High"] AND ^1% in ["Critical", "High"])
This example returns the list of timestamps of when the current issue's priority has changed to Critical or High.
Additional information

Parameters used in this function

ParameterInput (data type)Description
textField

TEXT

Any field code representing a text field or a selectable field.

condition

BOOLEAN

The condition is used to check the field value before and after the field change. 

The text value before the change is represented by ^0%, and by ^1% after the change.

Output

The function returns a NUMBER LIST of timestamps.

The timestamps are returned in ascending order.


Variant for numeric / date-time fields.

Syntax
fieldChangeTimes(numberField, condition) #Output: Number list
Examples
Parser expressionDescription
fieldChangeTimes(issue.dueDate, ^0 < ^1)
This example returns the timestamps of when the Due date has been edited to a higher value.
fieldChangeTimes({issue.cf10001}, abs(^0 - ^1) / ^0 >= 0.25)
This example returns the timestamps of when a number field called Passengers (field code {10001}) has been edited with a variation of at least 25% over its previous value.
Additional information

Parameters used in this function

ParameterInput (data type)Description
numberField

NUMBER

Any field code representing a number field (including dates).

condition

BOOLEAN

The condition is used to check the field value before and after the field change. 

The number value before the change is represented by ^0%, and by ^1% after the change.

Output

The function returns a NUMBER LIST

The timestamps are returned in ascending order.


Variant for text fields in multiple issues defined in an issue list.

Syntax
fieldChangeTimes(textField, issueList, condition) #Output: Number list
Examples
Parser expressionDescription
fieldChangeTimes(%{issue.summary}, subtasks(), ^0% !~~ "IMPORTANT" AND ^1% ~~ "IMPORTANT")
This example returns a list of timestamps of when the word "IMPORTANT" has been added the the summary of all current sub-tasks, ignoring the case.
fieldChangeTimes(%{issue.priority}, epic(), ^0% = null AND ^1% != null)
This example returns the list of timestamps of when the issue priority of the current issue's epic has been set.
fieldChangeTimes(%{issue.priority}, linkedIssues("is blocked by"), ^0% not in ["Critical", "High"] AND ^1% in ["Critical", "High"])
This example returns the list of timestamps of when the priority in all blocking linked issues has become Critical or High.
Additional information

Parameters used in this function

ParameterInput (data type)Description
textField

TEXT

Any field code representing a text field or a selectable field.

issueList

ISSUE LIST

A list of issues that will be checked. Learn more about Working with lists.
condition

BOOLEAN

The condition is used to check the field value before and after the field change. 

The text value before the change is represented by ^0%, and by ^1% after the change.

Output

The function returns a NUMBER LIST containing a sequence of sorted numeric values in ascending order for each parameter issue.


Variant for number fields in multiple issues defined in an issue list.

Syntax
fieldChangeTimes(numberField, issueList, condition) #Output: Number list
Examples
Parser expressionDescription
fieldChangeTimes({issue.dueDate}, subtasks(), ^0 < ^1)
This example returns the timestamps of when the Due Date has been edited to a higher value in any of the current sub-tasks.
fieldChangeTimes({issue.cf10001}, epic(), abs(^0 - ^1) / ^0 >= 0.25)
This example returns the timestamps when a number field called Passengers (field code {10001}) in the current issue's epic has been edited with a variation of at least 25% over its previous value
Additional information

Parameters used in this function

ParameterInput (data type)Description
numberField

NUMBER

Any field code representing a number field (including dates).

issueList

ISSUE LIST

A list of issues that will be checked. Learn more about Working with lists.
condition

BOOLEAN

The condition is used to check the field value before and after the field change. 

The number value before the change is represented by ^0%, and by ^1% after the change.

Output

The function returns a NUMBER LIST containing a sequence of sorted numeric values in ascending order for each parameter issue.

Not sure what this function will actually return? Try it out and test your expression.