You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

This JQL function is used for searching users with properties containing a date or date-time value

Syntax
usersWithDateTimePropertyValue(propertyName, operator, value, format) #Output: Users
Examples
Parser expressionDescription
assignee in usersWithDateTimePropertyValue("day_off", "<", "2021/11/03", "dd/MM/yy")
This example returns all issues where the Assignee's property day_off is before 2021/11/03, and it's written in the format dd/MM/yyyy.
reporter in usersWithDateTimePropertyValue("birthday", ">=", "1997/09/16 11:30", "MM-dd-yyyy [hh:mm]")
This example returns all issues where the Reporter's property birthday is after or the same day as 1997/09/16 11:30, and it's written in the format MM-dd-yyyy [hh:mm].
Additional information

Parameters used in this function

ParameterInput (data type)Description
propertyName

TEXT

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

TEXT

A valid comparison operator

value

TEXT

The value to compare with the property
format

TEXT

The date or date-time format in which the property value is written
Output

This function returns USER LIST.