Page History

Versions Compared

Old Version 4

changes.mady.by.user Iheb Kharab

Saved on Mar 20, 2020

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Aug 15, 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 a

Status

subtle	true
title	number

representing the sum of all the time logged in issues in milliseconds.

Output

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

The function returns a

Status

subtle	true
title	number

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

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issue list issuesissueList) #Output : Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeLogged(subtasks())

The function returns a

Status

subtle	true
title	number

representing the sum

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

milliseconds

full hours.

Learn more about numbers and mathematical functions.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>issueList

Status

subtle	true
title	data type	issue list

A list of issue to be evaluated. 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 all the time logged in issues in time interval defined by timestamps datetime_ini and datetime_end and If one or both timestamps are null, then it is assumed that the time period has not low or high time limit respectively.

Logged time is returned in milliseconds.

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(issue list issuesissueList, number datetime_inistartDate, number datetime_endendDate) #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 10th 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({

00057

system.currentDateTime}, LOCAL), addDays

(datePart

({

00057

system.currentDateTime}, LOCAL), 1, LOCAL))

The function returns a

Status

subtle	true
title	number

representing

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

Note that {00057} is field code for Current date and time

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

<parameter>issueList

Status

subtle	true
title	data type

Parameter description.

issue List

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

startDate<parameter>

Status

title

subtle	true

data type

Parameter description.

number

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

endDate<parameter>

Status

title

subtle	true

data type

number

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date)Parameter 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 all the time logged in issues by a user with the username user.

Logged time is returned in milliseconds.

UI Text Box

type	note

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

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

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issue list issuesissueList, string user) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeLogged(linkedIssues(), %{

00003})

The function returns a

Status

subtle	true
title	number

representing the sum of time logged by the assignee on linked issues.

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

%{00003}is field code for Assignee

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>issueList

Status

subtle	true
title	data type

Parameter description.

issue list

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

user<parameter>

Status

title

subtle	true

data type

	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

Parameter 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

the sum of all the time logged in issues by a user in a time interval defined by timestamps datetime_ini and datetime_end. If one or both timestamps are null, then it's assumed that the time interval hasn't low or high time limit respectively.

Logged time is returned in milliseconds.

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

UI Text Box

type	note

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

Code Block

language	bash
title	Syntax
linenumbers	true

timeLogged(issue list issuesissueList, number datetime_inistartDate, number datetime_end, stringendDate, user) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

timeLogged(subtasks(),

2018

2019/01/01,

2019

2020/01/01, %{

00003

issue.assignee})

The function returns a

Status

subtle	true
title	number

representing the sum of time logged by the assignee on subtasks during 2018.

%{00003} is field code for 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

title

subtle	true

data type

number

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

endDate

Parameter description.

Status

title

subtle	true

data type

Parameter description.

number

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

user<parameter>

Status

title

subtle	true

data type

Parameter description.

	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
id	1

Parser function cloud

Map

Notes

Workaround

Code Block

language	bash

%{sum(toNumberList(jiraExpression("issue.links.map(l=>l.linkedIssue)
.map(e=>e.timeSpent)")))}

It's only possible to do it using our General parser.

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

Parameter description.

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

data type

Content

Space Tools

Versions Compared

Old Version 4

New Version Current

Key

Image AddedUse cases and examples

Workaround