This JQL function returns users by checking against their user properties that contain date or date-time values.
|This example returns all issues where the assignee's property day_off is before 2021/11/03.|
|This example returns all issues where the reporter's property birthday is after or on the same day as 1997/09/16 11:30.|
|This example returns all issues where the assignee's property day_off is before 2020/08/15 12:30.|
This example returns all issues where the assignee's property day_off is before 2020/09/16 12:30.
Parameters used in this function
|Parameter||Input (data type)||Description|
The name of a user property containing a date or date-time value.
The property has to be saved in one of the following format:
A valid comparison operator. Allowed operators are:
The value to compare with the property, the following formats are accepted:
In case you use the format yyyy/MM/dd, the time part of the date will automatically be set to 00:00.
This function returns a TEXT LIST
If you want to search for issues, checking only if a property is being set ignoring it's value, have a look the the usersWithProperty() function.
The result is not what you expected? The number of returned issues feels too low?
By default, the maximum number of issues that will be returned by the JQL subquery, and thus can be processed by the logical expression is 1000.
To ensure the performance of your entire Jira instance, we limit the execution of the JQL function in terms of issue count and execution time. Please refer to your admin if you need to change the configuration.