timeInStatus() | Decadis App Help Center

This function returns the number of milliseconds the current issue has remained in a status with specific status.

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.

Bash

timeInStatus(statusName) #Output: Number

Examples

Expression parser	Description
Bash `timeInStatus("Open")`	This example returns the number of milliseconds the current issue has stayed in status "Open"
Bash `timeInStatus("Open") / {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.
Bash `timeInStatus(%{issue.status.previous}) / {MINUTE}`	This example returns the number of minutes the current issue has stayed in previous status.

Expression parser

Description

Bash

timeInStatus("Open")

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

Bash

timeInStatus("Open") / {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.

Bash

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

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

status.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
statusName	text	The input has to be a valid status name. Alternatively you can use field codes to retrieve the value.

Parameter

Input (data type)

Description

statusName

text

The input has to be a valid status

name. Alternatively you can use

field codes

to retrieve the value.

Output

This function returns a number

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.

Bash

timeInStatus(statusName, calendarName, timeZone) #Output: Number

Examples

Parser expression	Description
Bash `timeInStatus("Open", "my_schedule", LOCAL) / {HOUR}`	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 time zone. `{HOUR}` is a time macro used to convert the output to hours.

Additional information

Parameters used in this function

Parameter

Input (data type)

Description

statusName

text

The input has to be a valid status

name. Alternatively you can use

field codes

to retrieve the value.

calendarName

text

The input has to be a valid calendar

name. Learn more about

working with calendars

timeZone

timezone

The time zone used for the calculation.

Output

This function returns a number

Variant where you can additionally define multiple issues in an issue list.

The time across all issues will be summed up.

Bash

timeInStatus(statusName, issueList) #Output: Number

Examples

Parser expression	Description
Bash `timeInStatus("Open", subtasks()) / {HOUR}`	This example returns the number of hours the current issue's sub-tasks have stayed in status "Open" `{HOUR}` is a time macro used to convert the output to hours. subtasks() is a function to return all subtasks.

Additional information

Parameters used in this function

Parameter

Input (data type)

Description

statusName

text

The input has to be a valid status

name. Alternatively you can use

field codes

to retrieve the value.

issueList

issue list

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

Lists

Output

This function returns a number

Variant where you can define multiple issues in an issue list and additionally a custom calendar and time zone.

The time across all issues will be summed up.

Bash

timeInStatus(statusName, issueList, calendarName, timeZone) #Output: Number

Examples

Parser expression	Description
Bash `timeInStatus("Open", subtasks(), "my_schedule", LOCAL) / {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. `{HOUR}` is a time macro used to convert the output to hours. subtasks() is a function to return all subtasks.

Additional information

Parameters used in this function

Parameter	Input (data type)	Description
`statusName`	text	The input has to be a valid status name. Alternatively you can use field codes to retrieve the value.
`issueList`	issue list	The input has to be a valid issue list. Learn more about working with lists .
calendarName	text	The input has to be a valid calendar name. Learn more about working with calendars .
`timeZone`	timezone	The time zone used for the calculation.

Output

This function returns a number

📚 Use cases and examples

Use case	JWT feature	Workflow function	Field type	Automated action	Parser functions
Number of days an issue was in the Open status against a JWT calendar			Number		timeInStatus()