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 7 Next »

The function returns the NUMBER of milliseconds of a string field with code %{nnnnn} of the current issue that has a value satisfying a boolean expression predicate.

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

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

The function returns the NUMBER of milliseconds of the field summary (field code %{00000}) of the current issue that contained any of the words "ERROR" or "WARNING", ignoring the case.

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

The function returns the NUMBER of milliseconds of the field components (field code %{00094}) of the current issue that contained more than one selected component.

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

The function returns the NUMBER of milliseconds of the field priority (field code %{00017}) of the current issue that had a value of Critical or High.

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

Output

The function returns a NUMBER


The function returns the NUMBER 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.

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

Syntax
timeInValue(number field field, boolean expression predicate) #Output: Number
Examples
Parser expressionDescription
timeInValue({00012}, ^ != null)

The function returns the NUMBER of milliseconds of the field Due date (field code {00012}) of the current issue that had a value.

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

The function 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)

The function 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,...).

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

Output

The function returns a NUMBER


The function returns a NUMBER representing 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(string field field, issue list issues, boolean expression predicate) #Output: Number
Examples
Parser expressionDescription
Syntax
timeInValue(%{00000}, subtasks(), ^% ~~ "ERROR" OR ^% ~~ "WARNING"

The function 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.

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

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

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

The function 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.

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


The function returns a NUMBER representing 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(number field field, issue list issues, boolean expression predicate) #Output: Number
Examples
Parser expressionDescription
timeInValue({00012}, subtasks(), ^ != null

The function 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.

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

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

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

The function 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..

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


The 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(string field field, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription
timeInValue(%{00094}, count(toStringList(^%, ",")) > 1, "my_schedule", LOCAL)

The function 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 for the server's default time_zone.

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 for 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 for the server's default time_zone.

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

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

The function returns a NUMBER