Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


UI Text Box
sizemedium
typeinfo

This

...

JQL function returns projects with specific properties containing a numeric value.


Code Block
languagebash
titleSyntax
linenumberstrue
projectsWhereNumberProperty(

...

propertyName, operator, 

...

number) #Output: 

...

Text list

...


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue

...

project in projectsWhereNumberProperty(

...

"maximumNumberOfTryOuts", ">", 3

...

)


This example returns a list of projects where the

...

property called maximumNumberOfTryOuts

...

is bigger than 3e.g. text {maximumNumberOfTryOuts=5} is present in the project's description.


Code Block
languagebash
linenumberstrue

...

project in projectsWhereNumberProperty(

...

"numberOfLevels", "=", 5

...

)


This example returns a list of projects where the

...

property called numberOfLevels

...

is equal to 5e.g. text {numberOfLevels=5} is present in the project's description.



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description

...

propertyName

Status
subtletrue
titletext

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

Status
subtletrue
title

...

Comparison operator to be applied.

Expand
titlemore info...
  • "=" 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.

text

A valid comparison operator.

number

Status
subtletrue
titlenumber

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



UI Expand
titleOutput

This function returns a

Status
subtletrue
title

...

text list
.


Include Page
DECADIS:_snip_limit_JQL_functions
DECADIS:_snip_limit_JQL_functions



Page properties
hiddentrue


Short description

Returns projects with specific numeric properties.

Output

Status
subtletrue
titletext list

Label

Status
colourRed
titlestaff pick




Page properties
hiddentrue



Status
Tech review

Status
colourYellow
titleReady for review

Style guide

Status
colourGreen
titledone

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged

...