This JQL function is used for searching for users by checking against user properties that contain date or date-time values.

usersWithDateTimeProperty(propertyName, operator, value, format) #Output: User list
Parser expressionDescription
assignee in usersWithDateTimeProperty("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, written in the format dd/MM/yyyy.
reporter in usersWithDateTimeProperty("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, written in the format MM-dd-yyyy [hh:mm].

Parameters used in this function

ParameterInput (data type)Description
propertyName

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

A valid comparison operator

value

The value to compare with the property.

The date must have a format of yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm]. 

format

The date or date-time format in which the property value is written. Any format is allowed.

This function returns a .

Variant where it supports 12-hr and 24-hr format.

usersWithDateTimePropertyValue(String property, String comparator, DateTime value) #Output: User list
Parser expressionDescription
assignee in usersWithDateTimePropertyValue("day_off", "<", now())
This example returns all issues where the assignee's property day_off is before Today, written in the format MM-dd-yyyy [hh:mm]. (12-hr or 24-hr format)

Parameters used in this function

ParameterInput (data type)Description
String property

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

A valid comparison operator.

DateTime value

The value to compare with the property.

The date must have a format of yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm] in 12-hr or 24-hr format.

This function returns a .

Short description

Searches for users by checking on their date or date-time properties.

Output

Label


Status
Tech review

Style guide