Page History

Versions Compared

Old Version 43

changes.mady.by.user Thorsten Letschert

Saved on Sep 30, 2021

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Dec 06, 2021

Key

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

UI Text Box

size	medium
type	info

This JQL function returns users by checking against their user properties that contain date or date-time values.

Code Block

language	bash
title	Syntax
linenumbers	true

usersWithDateTimeProperty(propertyName, operator, value) #Output: Text list

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

assignee in usersWithDateTimeProperty("day_off", "<", "2021/11/03")

This example returns all issues where the assignee's property day_off is before 2021/11/03.

Code Block

language	bash
linenumbers	true

reporter in usersWithDateTimeProperty("birthday", ">=", "1997/09/16 [11:30]")

This example returns all issues where the reporter's property birthday is after or on the same day as 1997/09/16 11:30.

Code Block

language	bash
linenumbers	true

assignee in usersWithDateTimeProperty("day_off", "<", "2020/08/15 [12:30]")

This example returns all issues where the assignee's property day_off is before 2020/08/15 12:30.

Code Block

language	bash
linenumbers	true

assignee in usersWithDateTimeProperty("day_off", "<", "2020/09/16 [12:30]")

This example returns all issues where the assignee's property day_off is before 2020/09/16 12:30.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

propertyName

Status

subtle	true
title	text

The name of a user property containing a date or date-time value.

The property has to be saved in one of the following format:

yyyy/MM/dd
yyyy/MM/dd [hh:mm]

operator

Status

subtle	true
title	text

A valid comparison operator. Allowed operators are:

Operator	Description
=	Property must be equal to the specified value.
!=	Property must not be equal to the specified value.
<	Property must be lower than the specified value, meaning that the date saved date in the property must be before the specified date.
>	Property must be greater than the specified value, meaning that the date saved date in the property must be after the specified date.
<=	Property must be lower or equals to the specified value, meaning that the date saved date in the property must be before or equals to the specified date.
>=	Property must be greater or equals to the specified value, meaning that the date saved date in the property must be after or equals to the specified date.

value

Status

subtle	true
title	text

The value to compare with the property, the following formats are accepted:

yyyy/MM/dd [hh:mm]
yyyy/MM/dd

UI Text Box

type	info

In case you use the format yyyy/MM/dd, the time part of the date will automatically be set to 00:00.

UI Expand

title	Output

This function returns a

Status


subtle	true
title	text list

UI Text Box

type	tip

If you want to search for issues where a user as a specific text or numeric property value, have a look the the usersWithTextProperty or usersWithNumericProperty() function.

If you want to search for issues, checking only if a property is being set ignoring it's value, have a look the the usersWithProperty() function.

Include Page

	DECADIS:_snip_limit_JQL_functions
	DECADIS:_snip_limit_JQL_functions

Page properties

hidden	true

Short description

Returns users with specific date or date-time properties.

Output

Status


subtle	true
title	text list

Label

Status

colour	Red
title	staff pick

Page properties

hidden	true

Status

Tech review

Status

colour	Yellow
title	Ready for review

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

Content

Space Tools

Versions Compared

Old Version 43

New Version Current

Key