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
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 23 Next »
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 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 usersWithDateTimePropertyValue("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 usersWithDateTimePropertyValue("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:
|
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 date must have a format of yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm a] in 12-hr where |
format | TEXT | The date or date-time format in which the property value is written. Any format is allowed. |
This function returns a USER LIST.
Powered by Atlassian Confluence 8.5.7, themed by Refined 7.5.3 and Decadis AG