Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

fieldChangeTimes(textField, condition) #Output: Number list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

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.

Code Block

language	bash
linenumbers	true

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 been changed to Critical or High.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

textField

Status


subtle	true
title	text

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

condition

Status


subtle	true
title	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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	Number list

containing the timestamps in ascending order

UI Text Box

size	medium
type	info

Variant for numeric / date-time fields.

Code Block

language	bash
title	Syntax
linenumbers	true

fieldChangeTimes(numberField, condition) #Output: Number list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

fieldChangeTimes(issue.dueDate, ^0 < ^1)

This example returns the list of timestamps of when the Due date has been increased (updated to a higher value).

Code Block

language	bash
linenumbers	true

fieldChangeTimes({issue.cf10001}, abs(^0 - ^1) / ^0 >= 0.25)

This example returns the list of timestamps of when a number field called Passengers (with the custom field ID 10001) has been edited with a variation of at least 25% over its previous value.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

numberField

Status


subtle	true
title	number

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

condition

Status


subtle	true
title	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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	Number list

containing the timestamps in ascending order

UI Text Box

size	medium
type	info

Variant for text fields in multiple issues from a given issue list.

Code Block

language	bash
title	Syntax
linenumbers	true

fieldChangeTimes(textField, issueList, condition) #Output: Number list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

fieldChangeTimes(%{issue.summary}, subtasks(), ^0% !~~ "IMPORTANT" AND ^1% ~~ "IMPORTANT")

This example returns the list of timestamps of when the word "IMPORTANT" has been added the the summary of all current sub-tasks, ignoring the case.

Code Block

language	bash
linenumbers	true

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.

Code Block

language	bash
linenumbers	true

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.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

textField

Status


subtle	true
title	text

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

issueList

Status


subtle	true
title	issue list

A list of issues that will be checked. Learn more about Lists.

condition

Status


subtle	true
title	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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	text list

containing the timestamps in ascending order

UI Text Box

size	medium
type	info

Variant for numeric / date-time fields in multiple issues from a given issue list.

Code Block

language	bash
title	Syntax
linenumbers	true

fieldChangeTimes(numberField, issueList, condition) #Output: Number list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

fieldChangeTimes({issue.dueDate}, subtasks(), ^0 < ^1)

This example returns the list of timestamps of when the Due Date has been edited to a higher value in any of the current sub-tasks.

Code Block

language	bash
linenumbers	true

fieldChangeTimes({issue.cf10001}, epic(), abs(^0 - ^1) / ^0 >= 0.25)

This example returns the list of 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

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

numberField

Status


subtle	true
title	number

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

issueList

Status


subtle	true
title	issue list

A list of issues that will be checked. Learn more about Lists.

condition

Status


subtle	true
title	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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	Number list

containing the timestamps in the order of issue appearance

Use cases and examples

Page properties report

cql	label = "parser_func_fieldchangetimes" and space = currentSpace()

page pro

Page properties

hidden	true

Status

Tech review

Status

colour	Green
title	done

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Page properties

hidden	true

Short description

Returns the timestamps of when a field has changed satisfying a certain condition.

Output

Status


subtle	true
title	number list

Label

Content

Space Tools

Versions Compared

Old Version 28

New Version 29

Key

Use cases and examples