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 20 Next »

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

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

This example returns all issues where the Assignee's property dailyTasks is greater than 4.

vs.

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", "=", 11)

This example returns all issues where the Reporter's property remainingHolidays is equals to 11.

vs.

This example returns all issues where the reporter has a user property called remainingHolidays with a value of 11.

Does that example make sense?

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 USER 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.