Page History

Versions Compared

Old Version 4

changes.mady.by.user Iheb Kharab

Saved on Mar 19, 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.

Page properties

hidden	true

Status

Tech 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

Status

subtle	true
title	number

of milliseconds the current issue has remained in a status with name status_name.

Output

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

This function returns the number of The function returns the

Status

subtle	true
title	number

of milliseconds the current issue has remained in a status with name specific status_name.

If an issue has been in that status more than once, then duration will be summed up and the total time spent in the status will be returned.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInStatus(string status_namestatusName) #Output: Number

In order to display this value in a more readable way, the milliseconds should be transformed into a more readable unit, like in the following example:

UI Expand

title	Examples

Expression parser

Description

Code Block

language	bash
linenumbers	true

timeInStatus("Open")

The function

This example returns the

Status

subtle	true
title	number

number of milliseconds the current issue has stayed in status "Open"

UI Text Box

type	tip

Code Block

language	bash
linenumbers	true

timeInStatus("Open") / {

DAY} - for number of days, or timeInStatus("Open") / {HOUR} - for number of hours

HOUR}

This example returns the number of hours the current issue has stayed in status "Open"

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

Code Block

language	bash
linenumbers	true

timeInStatus(%{issue.status.previous}) / {MINUTE}

This example returns the number of minutes the current issue has stayed in previous status.

UI Expand

title	Additional information

Parameters used in this function

Parameter

Input (data type)

Description

statusName

Status


subtle	true
title	data type	text

The input has to be a valid status name. Alternatively you can use field codes to retrieve the valueParameter description.

UI Expand

title	Output

The This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

The function returns the

Status

subtle	true
title	number

of milliseconds the current issue has remained in a status with a name "status_name" within a schedule_name for a given time_zone. Variant where you additionally define a custom calendar and time zone.

If an issue has been in that status more than once, then duration will be summed up and the total time spent in the status will be returned.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInStatus(string status_namestatusName, string schedule_namecalendarName, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeInStatus("Open", "my_schedule", LOCAL) / {HOUR}

the function returns the

Status

subtle	true
title	number

of milliseconds

This example returns the number of hours the current issue has stayed in status "Open" within the schedule called "my_schedule" matching the server's default

timeZone

time zone.

UI Text Box

type	info

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

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>statusName

Status

title

subtle	true

data type

Parameter description.

text

The input has to be a valid status name. Alternatively you can use field codes to retrieve the value.

calendarName<parameter>

Status

title

subtle	true

data type

text

The input has to be a valid calendar name. Learn more about working with calendarsParameter 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

-textbox

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

The This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

the function returns a

Status

subtle	true
title	number

representing the sum of milliseconds Variant where you can additionally define multiple issues in an issue list issues have remained in a status with the name "status_name". If an issue from that list has been in that status more than once, then list.

The time across all issues duration will be summed up and the total time spent in the status will be returned.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInStatus(string status_namestatusName, issue list issuesissueList) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeInStatus("Open", subtasks()

The function returns the

Status

subtle	true
title	number

of milliseconds the

) / {HOUR}

This example returns the number of hours the current issue's sub-

tasks

tasks have stayed in status "Open"

ui-text-box

type	info

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

subtasks() is a function to return all subtasks.

ui-expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>statusName

Status

title

subtle	true

data type

Parameter description.

text

The input has to be a valid status name. Alternatively you can use field codes to retrieve the value.

issueList<parameter>

Status

title

subtle	true

data type

issue list

The input has to be a valid issue list. Learn more about ListsParameter description.

UI Expand

title	Output

The This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

The function returns a

Status

subtle	true
title	number

representing the sum of milliseconds Variant where you can define multiple issues in an issue list issues have remained in a status with the name "status_name" within a schedule named "schedule_name" for a given time_zone. If an issue from that list has been in that status more than once, then duration will be summed up and the total time spent in the status will be returnedlist and additionally a custom calendar and time zone.

The time across all issues will be summedup.

Code Block

language	bash
title	Syntax
linenumbers	true

timeInStatus(string status_namestatusName, issue list issuesissueList, string schedule_namecalendarName, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeInStatus("Open", subtasks(), "my_schedule", LOCAL)

The function returns the

Status

subtle	true
title	number

of milliseconds

 / {HOUR}

This example returns the number of hours the current issue's sub-tasks have stayed in status "Open" within the schedule called "my_schedule" matching the server's default timeZone.

UI Text Box

type	info

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

subtasks() is a function to return all subtasks.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>statusName

Status

title

subtle	true

data type

Parameter description.

text

The input has to be a valid status name. Alternatively you can use field codes to retrieve the value.

issueList<parameter>

Status

title

subtle	true

data type

Parameter description.

issue list

The input has to be a valid issue list. Learn more about working with lists.

calendarName<parameter>

Status

title

subtle	true

data type

text

The input has to be a valid calendar name. Learn more about working with calendarsParameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

ui-expand

title

Learn more about timezones

Excerpt Include

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

	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_timeinstatus" 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

number

Page properties

hidden	true

Short description

Returns the time the current issue has remained in a specific status.

Output

Status

subtle	true
title	number

Available since

Status

subtle	true
colour	Red
title	needs lookup

Label

Status


colour	Red
title	staff pick

The function returns a

Status

subtle

true

title

Content

Space Tools

Versions Compared

Old Version 4

New Version Current

Key

Image AddedUse cases and examples