Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

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

Compare with Current View Page History

« Previous Version 18 Next »

This function returns the time a text field has had a specific value. 

The value check (a boolean condition) is being initialized with ^%. 

Syntax
timeInValue(textField, condition) #Output: Number
Examples
Parser expressionDescription
timeInValue(%{issue.summary}, ^% ~~ "ERROR" OR ^% ~~ "WARNING") / {HOUR}

This example returns the number of hours the field summary of the current issue contained any of the words "ERROR" or "WARNING", ignoring the case.

{HOUR} is a time macro used to convert the output to hours.

timeInValue(%{issue.components}, count(toStringList(^%, ",")) > 1) / {HOUR}

This example returns the number of hours the field components of the current issue contained more than one selected component.

{HOUR} is a time macro used to convert the output to hours.

To achieve this, the following functions are used:

timeInValue(%{issue.priority}, ^% in ["Critical", "High"]) / {HOUR}

This example returns the number of hours the field priority of the current issue had a value of Critical or High.

{HOUR} is a time macro used to convert the output to hours.

Additional information

Parameters used in this function

ParameterInput (data type)Description
textField

TEXT

The input has to be a valid text field represented by a field code.
condition

TEXT

The calculation will only be performed if the boolean condition is being met.
Output

This function returns a NUMBER


Variant for number or date-time fields.

Syntax
timeInValue(numberField, condition) #Output: Number
Examples
Parser expressionDescription
timeInValue({issue.dueDate}, ^ != null) / {HOUR}

This example returns the number of hours the of the field Due date of the current issue that had a value.

timeInValue({10001}, ^ >= 5 AND ^ <= 10)

This example returns the number of milliseconds of a hypothetical numeric field called Passengers (field code {10001}) of the current issue that remained between 5 and 10.

timeInValue({10001}, modulus(^, 2) = 0)

This example returns the number of milliseconds of a hypothetical numeric field called Passengers (field code {10001}) of the current issue that has an even value (2, 4, 6,...).

To achieve this, the following functions are used:

Additional useful functions can be found here: Numbers

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.

Output

This function returns a NUMBER


This function returns the sum of milliseconds of a string field with code %{nnnnn} of the current issue that has a value satisfying a boolean expression predicate in distinct issues.

Where the string value of the field with code %{nnnnn} is represented by ^%.

Syntax
timeInValue(text field field, issue list issues, boolean expression predicate) #Output: Number
Examples
Parser expressionDescription
Syntax
timeInValue(%{00000}, subtasks(), ^% ~~ "ERROR" OR ^% ~~ "WARNING"

This example returns a number representing the sum of milliseconds  of the field summary (field code %{00000}) of all sub-tasks of the current issue that contained any of the words "ERROR" or "WARNING", ignoring the case.

To achieve this, the following functions are used:

Syntax
timeInValue(%{00094}, epic(), count(toStringList(^%, ",")) > 1)

This example returns the number of milliseconds of the field components (field code %{00094}) in a linked Epic issue that contained more than one selected component.

To achieve this, the following functions are used:

Syntax
timeInValue(%{00017}, filterByIssueType(linkedIssues(), "Bug, New Feature"), ^% in ["Critical", "High"])

This example returns a number representing the sum of milliseconds of all linked Bugs and New features of the current issue that had a priority (field code %{00017}) value of Critical or High.

To achieve this, the following functions are used:

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.

xxx

DATA TYPE

Parameter description.
Output

This function returns a NUMBER


This function returns the sum of milliseconds of a number or date-time field with code {nnnnn}of the current issue that has a value satisfying a boolean expression predicate in distinct issues.

Where the string value of the field with code {nnnnn} is represented by ^.

Syntax
timeInValue(numberField, issueList, condition) #Output: Number
Examples
Parser expressionDescription
timeInValue({00012}, subtasks(), ^ != null

This example returns the number of milliseconds of the field Due Date (field code {00012}) of all sub-tasks of the current issue that had a value.

To achieve this, the following functions are used:

timeInValue({10001}, epic(), ^ >= 5 AND ^ <= 10)

This example returns the number of milliseconds of a hypothetical numeric field called Passengers (field code {10001}) of an Epic issue that had a value between 5 and 10.

To achieve this, the following functions are used:

timeInValue({10001}, filterByIssueType(linkedIssues(), "Bug, New Feature"), modulus(^, 2) = 0)

This example returns the number  of milliseconds of a hypothetical numeric field called Passengers (field code {10001}) that had an even value in any linked Bug or New Feature.

To achieve this, the following functions are used:

Additional useful functions can be found here: Numbers

Additional information

Parameters used in this function

ParameterInput (data type)Description
numberField

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.

xxx

DATA TYPE

Parameter description.
Output

This function returns a NUMBER


This function returns the number of milliseconds of a string field with code %{nnnnn}of the current issue that had a value satisfying a boolean expression predicate.

Where the string value of the field with code %{nnnnn} is represented by ^%.

The time being calculated by this function is only counted during a defined schedule with a name "schedule_name" in a certain time_zone. 

Syntax
timeInValue(text field field, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
timeInValue(%{00094}, count(toStringList(^%, ",")) > 1, "my_schedule", LOCAL)

This example returns the number of milliseconds of the field components (field code %{00094}) of the current issue that contained more than one selected component, within a schedule named "my_schedule" in the server's default time_zone.

To achieve this, the following functions are used:

timeInValue(%{00017}, ^% in ["Critical", "High"], "my_schedule", LOCAL)

The function returns the number of milliseconds of the current issue that had a priority value of Critical or High (field code %{00017}), within a schedule named "my_schedule" in the server's default time_zone.

timeInValue(%{00000}, ^% ~~ "ERROR" OR ^% ~~ "WARNING", "my_schedule", LOCAL)

The function returns the number of milliseconds the field summary (field code %{00000}) of the current issue that contained any of the words "ERROR" or "WARNING", ignoring the case, within a schedule named "my_schedule" in the server's default time_zone.

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

This function returns a NUMBER


This function returns the number of milliseconds of a number or date-time field with code {nnnnn} of the current issue that had a value satisfying a boolean expression predicate.

Where the numeric value of the field with code {nnnnn} is represented by ^.

The time being calculated by this function is only counted during a defined schedule with name "schedule_name" in a certain time_zone.

Syntax
timeInValue(text field field, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
timeInValue({00012}, ^ != null, "my_schedule", LOCAL)

This example returns the number of milliseconds the field Due Date (field code {00012}) of the current issue that had a value, ignoring the case, within a schedule named "my_schedule" in the server's default time_zone.

timeInValue({10001}, ^ >= 5 AND ^ <= 10, "my_schedule", LOCAL)

This example returns the number of milliseconds of a hypothetical numeric field called Passengers (field code {10001}) of the current issue that had a value between 5 and 10, within a schedule named "my_schedule" in the server's default time_zone.

timeInValue({10001}, modulus(^, 2) = 0, "my_schedule", LOCAL)

This example returns the number of milliseconds a hypothetical numeric field called Passengers (field code{10001}) in current issue that had an even value, within a schedule named "my_schedule" in the server's default time_zone.

To achieve this, the following functions are used:

Additional useful functions can be found here: Numbers

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

This function returns a NUMBER


This function returns the sum of milliseconds of a string field with code %{nnnnn} that had a value satisfying a boolean expression predicate in distinct issues.

Where the value of the field with code %{nnnnn} is represented by ^%. 

The time being calculated by this function is only counted during a defined schedule with name "schedule_name" in a certain time_zone.

Syntax
timeInValue(text field field, issue list issues, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
timeInValue(%{00000}, subtasks(), ^% ~~ "ERROR" OR ^% ~~ "WARNING", "my_schedule", LOCAL)

This example returns the sum of milliseconds of the fields summary (field code %{00000}) of all sub-tasks of the current issue that contained any of the words "ERROR" or "WARNING", ignoring the case, within a schedule named "my_schedule" in the server's default time_zone.

To achieve this, the following functions are used:

timeInValue(%{00094}, epic(), count(toStringList(^%, ",")) > 1, "my_schedule", LOCAL)

This example returns the number of milliseconds of the field components (field code %{00094}) in the linked Epic issue that contained more than one selected component, within a schedule named "my_schedule" in the server's default time_zone.

To achieve this, the following functions are used:

timeInValue(%{00017}, filterByIssueType(linkedIssues(), "Bug, New Feature"), ^% in ["Critical", "High"], "my_schedule", LOCAL)

This example returns the sum of milliseconds of all linked Bugs and New Features of the current issue that had a priority (field code %{00017}) value of Critical or High, within a schedule named "my_schedule" in the server's default time_zone. 

To achieve this, the following functions are used:

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

This function returns a NUMBER


This function returns the sum of milliseconds of a number or date-time field with code {nnnnn} has had a value satisfying a boolean expression predicate in distinct issues, where the numeric value of the field with code {nnnnn} is represented by ^. 

The time being calculated by this function is only counted during a defined schedule with name "schedule_name" in a certain time_zone.

Syntax
timeInValue(number field field, issue list issues, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
timeInValue({00012}, subtasks(), ^ != null, "my_schedule", LOCAL)

This example returns the number of milliseconds the field Due date (field code {00012}) of all sub-tasks of the current issue that had a value, within a schedule named "my_schedule" in the server's default time_zone. 

To achieve this, the following functions are used:

timeInValue({10001}, epic(), ^ >= 5 AND ^ <= 10, "my_schedule", LOCAL)

This example returns the number of milliseconds a hypothetical numeric field called Passengers (field code {10001}) in the linked Epic issue has had a value between 5 and 10, within a schedule named "my_schedule" in the server's default time_zone. 

To achieve this, the following functions are used:

timeInValue({10001}, filterByIssueType(linkedIssues(), "Bug, New Feature"), modulus(^, 2) = 0, "my_schedule", LOCAL)

This example returns the number of milliseconds a hypothetical numeric field called Passengers (field code {10001}) that had an even value in any linked Bug or New Feature, within a schedule named "my_schedule" in the server's default time_zone. 

To achieve this, the following functions are used:

Additional useful functions can be found here: Numbers

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

This function returns a NUMBER