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 expression | Description |
|---|---|
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]. |
assignee in usersWithDateTimeProperty("day_off", "<", "2020/08/15 12:30", "MM-dd-yyyy [hh:mm]")
| This example returns all issues where the assignee's property day_off is before 2020/08/15 12:30 , written in the format MM-dd-yyyy [hh:mm] (24-hr format) |
assignee in usersWithDateTimeProperty("day_off", "<", "2020/09/16 12:30", "MM-dd-yyyy [hh:mm a]")
| This example returns all issues where the assignee's property day_off is before 2020/09/16 12:30 PM, written in the format MM-dd-yyyy [hh:mm a] (12-hr format AM/PM) 12-hr and 24-hr format:
|
Additional information
Parameters used in this function
| Parameter | Input (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 following formats are accepted: yyyy/MM/dd [hh:mm], yyyy/MM/dd, yyyy-MM-dd [hh:mm], or yyyy-MM-dd |
format | TEXT | The date or date-time format in which the property value is written. Any format is allowed. The date must have a format of yyyy/MM/dd [hh:mm] for 24-hr format or yyyy-MM-dd [hh:mm a] for 12-hr format where |
Output
This function returns a USER LIST.
