This JQL function returns users by checking against their user properties that contain numeric values.

Syntax
usersWithNumericProperty(propertyName, operator, number) #Output: Text list
Examples
Parser expressionDescription
assignee in usersWithNumericProperty("dailyTasks", ">", 4)

This example returns all issues where the current assignee has a user property called dailyTasks with a value greater than 4.

reporter in usersWithNumericProperty("remainingHolidays", ">", 15)

This example returns all issues where the reporter has a user property called remainingHolidays with a value greater than 15.

Additional information

Parameters used in this function

ParameterInput (data type)Description
propertyName

TEXT

The name of an user property containing a numeric value.
operator

TEXT

The operator used to compare the actual value with the expected value. Allowed operators are:

ComparatorDescription
=Property value must be equal to the specified one.
!=Property value must not be equal to the specified one.
>Property value must be greater than the specified one, ignoring the case.
<Property value must be lower than the specified one, ignoring the case.
number

NUMBER

The number to be compared with the value stored in the user property.
Output

This function returns a TEXT LIST

If you want to search for issues where a user as a specific text or date property value, have a look the the usersWithTextProperty() or usersWithDateTimeProperty() function.

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.