Page History

Versions Compared

Key

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

UI Text Box

size	medium
type	info

This function returns the sum of all the time logged on issues in milliseconds.

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issueList) #Output : Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeLogged(subtasks())

This example returns the sum of time logged in the current issue's sub-tasks in milliseconds.

Code Block

language	bash
linenumbers	true

timeLogged(subtasks()) / {HOUR}

This example returns the sum of time logged in the current issue's sub-tasks in hours.

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.

Code Block

language	bash
linenumbers	true

round(timeLogged(subtasks()) / {HOUR})

This example returns the sum of time logged in the current issue's sub-tasks in full hours.

Learn more about numbers and mathematical functions.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

issueList

Status

subtle	true
title	issue list

A list of issue to be evaluated. Learn more about Lists.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

Variant where you can additionally define the time interval when work was logged.

If any of the fields defined for the interval returns null the parameter will be ignored.

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issueList, startDate, endDate) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeLogged(subtasks(), 2020/01/01, 2020/01/10) / {HOUR}

This example returns the hours logged on all subtasks of the current issue between January 1st and January 7th of 2020.

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.

Code Block

language	bash
linenumbers	true

timeLogged(issuesUnderEpic(), datePart({system.currentDateTime}, LOCAL), addDays({system.currentDateTime}, LOCAL), 1, LOCAL))

This example returns the sum of time logged today in issues under the current issue's Epic.

The extract the date part of the current date (represented by its field code) the function datePart() is used.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

issueList

Status

subtle	true
title	issue List

A list of issues to be evaluated. Learn more about working with lists.

startDate

Status


subtle	true
title	number

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

endDate

Status


subtle	true
title	number

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

Variant where you can additionally limit the results to certain users.

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issueList, user) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeLogged(linkedIssues(), %{issue.assignee}) / {HOUR}

This example returns the sum of time logged on all linked issues by the current assignee.

UI Text Box

type	info

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

linkedIssues() is a function to return all linked issues.

Code Block

language	bash
linenumbers	true

timeLogged(subtasks(), %{issue.assignee}) / {HOUR}

This example returns the sum of time logged on all subtasks of the current issue by the current assignee.

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

issueList

Status

subtle	true
title	issue list

A list of issues to be evaluated. Learn more about working with lists.

user

Status


subtle	true
title	text

Limits the results to certain users. Users can also be retrieved by using field codes.

UI Text Box

type	info

This parameter can contain a single user name (not to be confused with user's full name), or a comma separated list of usernames, group names or project role names.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

Variant where you can additionally define the time interval when work was logged by certain users.

If any of the fields defined for the interval returns null the parameter will be ignored.

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issueList, startDate, endDate, user) #Output: Number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

timeLogged(subtasks(), 2019/01/01, 2020/01/01, %{issue.assignee}) / {HOUR}

This example returns the hours logged on all subtasks of the current issue during the year 2019 by the current assignee.

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

issueList

Status

subtle	true
title	issue List

A list of issues to be evaluated. Learn more about working with lists.

startDate

Status


subtle	true
title	number

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

endDate

Status


subtle	true
title	number

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

user

Status


subtle	true
title	text

Limits the results to certain users. Users can also be retrieved by using field codes.

UI Text Box

type	info

This parameter can contain a single user name (not to be confused with user's full name), or a comma separated list of usernames, group names or project role names.

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_timelogged" and space = currentSpace()

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

Page properties

hidden	true

Short description

Returns the sum of all the time logged on issues.

Output

Status

subtle	true
title	number

Available since

Status


subtle	true
colour	Red
title	needs lookup

Label

Content

Space Tools

Versions Compared

Old Version 20

New Version 21

Key

Image AddedUse cases and examples