Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

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

Compare with Current View Page History

« Previous Version 18 Next »

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

Syntax
usersWithDateTimeProperty(propertyName, operator, value, format) #Output: User list
Examples
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].
Additional information

Parameters used in this function

ParameterInput (data type)Description
propertyName

TEXT

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

TEXT

A valid comparison operator

value

TEXT

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

TEXT

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

This function returns a USER LIST.

Variant supporting 12-hr and 24-hr format:

  • 12-hr format:  MM-dd-yyyy [hh:mm a] where a stands for AM/PM
  • 24-hr format: MM-dd-yyyy [hh:mm]
Syntax
usersWithDateTimePropertyValue(String property, String comparator, DateTime value, format) #Output: User list
Examples
Parser expressionDescription
assignee in usersWithDateTimePropertyValue("day_off", "<", "2020/09/16 11:30", "MM-dd-yyyy [hh:mm]")
This example returns all issues where the assignee's property day_off is before 2020/09/16 11:30 , written in the format MM-dd-yyyy [hh:mm] (24-hr format)
assignee in usersWithDateTimePropertyValue("day_off", "<", "2020/09/16 23:30 AM", "MM-dd-yyyy [hh:mm a]")

This example returns all issues where the assignee's property day_off is before 2020/09/16 11:30 PM, written in the format MM-dd-yyyy [hh:mm a] (12-hr format AM/PM)

Additional information

Parameters used in this function

ParameterInput (data type)Description
String property

TEXT

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

TEXT

A valid comparison operator.

DateTime value

TEXT

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 a] in 12-hr

format

TEXT

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

This function returns a USER LIST.