Status
Tech review



This function is used for searching numeric values in project properties.


projectsWhereNumberProperty( project_property, operator, numeric_literal ) #Output: Project list



Parser expressionDescription


projects in projectsWhereNumberProperty( maximumNumberOfTryOuts, ">", 3 )


This example returns a list of projects where the 'maximumNumberOfTryOuts' is bigger than 3.


projects in projectsWhereNumberProperty( numberOfLevels, "=", 5 )


This example returns a list of projects where the 'numberOfLevels' is equal to 5.



Parameters used in this function

ParameterInput (data type)Description
project_property

The name of a project property containing a numeric value.
operator

Comparison operator to be applied.

  • "=" strict equal operator.
  • "!="  strict not an equal operator.
  • "~"  approximate equal operator (case insensitive and trims blanks).
  • "!~" approximate not equal operator (case insensitive and trims blanks).
  • "matches" The value of project property matches a regular expression.
  • "doesn't match" The value of project property doesn't match a regular expression.
  • ">, >=, <, <=" lexicographical order operators.


numeric_literal

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



This function returns a




Short description

JQL function to search for specific numeric properties.

Output

Label