Page History

Versions Compared

Old Version 12

changes.mady.by.user Iheb Kharab

Saved on May 22, 2020

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Jan 06, 2022

Key

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

UI Text Box

size	medium
type	info

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

The field's value in referenced with %{seed.text} in the logical condition.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(textField, condition) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue(%{issue.summary}, %{seed.text} ~~ "ERROR" OR %{seed.text} ~~ "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.

UI Text Box

type	info

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

Code Block

language	bash
linenumbers	true

timeInValue(%{issue.components}, count(toStringList(%{seed.text}, ",")) > 1

Page properties

hidden	true

StatusTech review

Status

title	todo

Style guide

Status

title	todo

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 time an issue field has had a specific value.

Output

Status

subtle	true
title	number

Available since StatussubtletruecolourRedtitleneeds lookup

UI Text Box

size	medium
type	info

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

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

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(textField, condition) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue(%{issue.summary}, ^% ~~ "ERROR" OR ^% ~~ "WARNING") / {HOUR}

This example This example returns the number of hours the field summarycomponents of the current issue contained any of the words "ERROR" or "WARNING", ignoring the case. more than one selected component.

UI Text Box

type	info

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

To achieve this, the following functions are used:

Code Block

language

Code Block

language	bash
linenumbers	true

timeInValue(%{issue.componentspriority}, count(toStringList(^% %{seed.text} in ["Critical", ",High")]) > 1) / {HOUR}

This example returns the This example returns the number of hours hours the field componentsfield priority of the current issue contained more than one selected component.had a value of Critical or High.

This example uses these functions:

count()

toString()code

UI Text Box

type	info

Info

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

language

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

UI Expand

title

bash

linenumbers

true

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

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

UI Expand

title	Additional information

Additional information

Parameters used in this function

Parameter	Input (data type)	Description

Parameters used in this function

Parameter Input (data type) Description

textField

Status


subtle	true
title	text

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

condition

Status


subtle	true
title	text

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

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

Variant for number or date-time fields.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(numberField, condition) #Output: Number

expandtitle information

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue({issue.dueDate}, ^{seed.number} != null) / {HOUR}

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

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, ^{seed.number} >= 5 AND ^{seed.number} <= 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.

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, modulus(^{seed.number}, 2) = 0)

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

To achieve this, the following functions are used:

modulus()

ui-text-

box

type

tip

Additional

useful functions can be found here: Numbers

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

xxxnumberField

Status


subtle	true
title	data type

Parameter description.

text

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

conditionxxx

Status


subtle	true
title	data type	text

The calculation will only be performed if the logical condition is being metParameter description.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

The 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 ^%Variant for text fields where you can additional specify an issue list instead taking the field from the current issue. The function returns the sum of milliseconds of each issue in the given list.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(stringtextField, field field, issue list issues, boolean expression predicateissueList, condition) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(%{00000issue.summary}, subtasks(), ^%%{seed.text} ~~ "ERROR" OR ^%%{seed.text} ~~ "WARNING") / {MINUTE}

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

To achieve this, the following functions are used:

subtasks()

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(%{00094issue.components}, epic(), count(toStringList(^%%{seed.text}, ",")) > 1)

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

To achieve this, the following functions are used:

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(%{00017issue.priority}, filterByIssueType(linkedIssues(), "Bug, New Feature"), ^%%{seed.text} in ["Critical", "High"]) / {HOUR}

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

To achieve this, the following functions are used:

UI Expand

title

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

xxxtextField

Status


subtle	true
title	data type	text

Any given text fieldParameter description.

xxxissueList

Status


subtle	true
title	data type	Issue list

Any given issue list. Usually this value is retrieved from a function (e.g. linkedIssues() or subtasks()).

condition

Parameter description.

xxx

Status


subtle	true
title	data type	text

The calculation will only be performed if the logical condition is being met

Parameter description

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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

Variant of number or date-time fields.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(numberField, issueList, condition) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue({00012issue.dueDate}, subtasks(), ^{seed.number} != null

This example returns the number of milliseconds of the field the sub-tasks' 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:

subtasks()

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, epic(), ^{seed.number} >= 5 AND ^{seed.number} <= 10)

This example returns the number of milliseconds of a hypothetical the epic's 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:

epic()

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, filterByIssueType(linkedIssues(), "Bug, New Feature"), modulus(^{seed.number}, 2) = 0)

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

To achieve this, the following functions are used:

UI Text Box

type	tip

Additional useful functions can be found here: Numbers

Parameter description

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

numberField

Status

title

subtle	true

data type

text

Any given number field.

xxx

issueList

Status

title

subtle	true

data type

Parameter description.

xxx

issue list

Any given issue list. Usually this value is retrieved from a function (e.g. linkedIssues() or subtasks()).

condition

Status

title

subtle	true

data typeParameter description

text

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

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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.

Variant where you additionally can define a custom calendar and time zone.

The field's value in referenced with ^% in the boolean condition.

Code Block

language

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(string field fieldtextField, boolean expression predicatecondition, string schedule_namecalendar, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue(%{00094issue.components}, count(toStringList(^%%{seed.text}, ",")) > 1, "my_schedulecalendar", LOCAL)

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

To achieve this, the following functions are used:

Code Block

language	bash
linenumbers	true

timeInValue(%{00017issue.priority}, ^%%{seed.text} in ["Critical", "High"], "my_schedulecalendar", LOCAL)

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

Code Block

language	bash
linenumbers	true

timeInValue(%{00000issue.summary}, ^%%{seed.text} ~~ "ERROR" OR ^%%{seed.text} ~~ "WARNING", "my_schedulecalendar", 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 calendar named "my_schedulecalendar" in the server's default time _ zone.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

xxxtextField

Status


subtle	true
title	data type	text

Any given text fieldParameter description.

xxxcondition

Status


subtle	true
title	data type	text

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

calendar

Parameter description.

xxx

Status


subtle	true
title	data type	text

A valid calendar nameParameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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

Variant of number or date-time fields.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(number field fieldnumberField, boolean expression predicatecondition, string schedule_namecalendar, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue({00012issue.dueDate}, ^{seed.number} != null, "my_schedulecalendar", 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 calendar named "my_schedulecalendar" in the server's default time _ zone.

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, ^{seed.number} >= 5 AND ^{seed.number} <= 10, "my_schedulecalendar", LOCAL)

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

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, modulus(^{seed.number}, 2) = 0, "my_schedulecalendar", LOCAL)

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

To achieve this, the following functions are used:

modulus()

ui-text-box

type	tip

Additional useful functions can be found here: Numbers

expand

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

xxxnumberField

Status


subtle	true
title	data type	text

Any given number fieldParameter description.

xxxcondition

Status


subtle	true
title	data type	text

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

calendar

Parameter description.

xxx

Status


subtle	true
title	data type	text

A valid calendar nameParameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

UI Text Box

type

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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

Variant where you can additionally specify an issue list.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(textField, issueList, condition, calendar, timeZone

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(string field field, issue list issues, boolean expression predicate, string schedule_name, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue(%{00000issue.summary}, subtasks(), ^%%{seed.text} ~~ "ERROR" OR ^%%{seed.text} ~~ "WARNING", "my_schedulecalendar", 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 the sub-tasks' fields summary contained any of the words "ERROR" or "WARNING", ignoring the case, within a schedule named calendar named "my_schedulecalendar" in the server's default time _ zone.

To achieve this, the following functions are used:

subtasks()

Code Block

language	bash
linenumbers	true

timeInValue(%{00094issue.components}, epic(), count(toStringList(^%%{seed.text}, ",")) > 1, "my_schedulecalendar", 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 epic's field components contained more than one selected component, within a schedule named calendar named "my_schedulecalendar" in the server's default time _ zone. .

To achieve this, the following functions are used:

Code Block

language	bash
linenumbers	true

timeInValue(%{00017issue.priority}, filterByIssueType(linkedIssues(), "Bug, New Feature"), ^%%{seed.text} in ["Critical", "High"], "my_schedulecalendar", 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 the linked Bugs' and New Features' field priority had a value of Critical or High, within a calendar named "my_calendar" in the server's default time _ zone.

To achieve this, the following functions are used:

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

xxxtextField

Status


subtle	true
title	data type	text

Any given text fieldParameter description.

xxxissueList

Status


subtle	true
title	data type	issue list

Any given issue list. Usually this value is retrieved from a function (e.g. linkedIssues() or subtasks()).

condition

Parameter description.

xxx

Status


subtle	true
title	data type	text

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

calendar

Parameter description.

xxx

Status


subtle	true
title	data type	text

A valid calendar nameParameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

UI Text Box

type	tip

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

the function returns the sum of milliseconds of a Variant with 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.

fields.

Code Block

title
language	bash

Code Block

language	bash
title	Syntax
linenumbers	true

timeInValue(number field field, issue list issues, boolean expression predicate, string schedule_name, timeZone time_zonenumberField, issueList, condition, calendar, timeZone) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeInValue({00012issue.dueDate}, subtasks(), ^{seed.number} != null, "my_schedulecalendar", LOCAL)

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

To achieve this, the following functions are used:

subtasks()

Code Block

language	bash
linenumbers	true

timeInValue({10001issue.cf10001}, epic(), ^{seed.number} >= 5 AND ^{seed.number} <= 10, "my_schedulecalendar", LOCAL)

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

Code Block

language	bash
linenumbers	true

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.

calendar" in the server's default time zone.

To achieve this, the following functions are used:

epic()

Code Block

language	bash
linenumbers	true

timeInValue({issue.cf10001}, filterByIssueType(linkedIssues(), "Bug, New Feature"), modulus({seed.number}, 2) = 0, "my_calendar", LOCAL)

This example returns the sum of milliseconds the linked Epics' and New Features' numeric field Passengers had an even value, within a calendar named "my_calendar" in the server's default time zone.

To achieve this, the following functions are used:

UI Text Box

type	tip

Additional useful functions can be found here: Numbers

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

numberField

Status


subtle	true
title	text

Any given number field.

issueList

Status


subtle	true
title	issue list

Any given issue list. Usually this value is retrieved from a function (e.g. linkedIssues() or subtasks()).

condition

Status


subtle	true
title	text

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

calendar

Status


subtle	true
title	text

A valid calendar name.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

Image AddedUse cases and examples

Page properties report

firstcolumn	Use case
headings	JWT feature, Workflow function, Field type, Automated action, Parser functions
cql	label = "parser_func_timeinvalue" and space = currentSpace()

Page properties

hidden	true
id	1

Parser function cloud
Map
Notes	Not possible because that kind of information is not available.

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

Parameters used in this function

The time zone used for the calculation.

Page properties

hidden	true

Short description

Returns the time an issue field has had a specific value.

Output

Status

subtle	true
title	number

Available since

Status


subtle	true
colour	Red
title	needs lookup

Label

Status


colour	Red
title	staff pick

UI Expand

title	Additional information

Parameter Input (data type) Description

xxx

Status

subtle true

title data type

Parameter description. xxx

Status

subtle true

title data type

Parameter description. xxx

Status

subtle true

title data type

Parameter description. xxx

Status

subtle true

title data type

Parameter description. timeZone

Status

subtle true

title timezone

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a Statussubtletruetitlenumber

Content

Space Tools

Versions Compared

Old Version 12

New Version Current

Key

Parameters used in this function

Image AddedUse cases and examples

Parameters used in this function