Versions Compared

Key

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


UI Text Box
sizemedium
typeinfo

This JQL function is used for searching project returns projects with specific properties containing a numeric value.


Code Block
languagebash
titleSyntax
linenumberstrue
projectsWhereNumberProperty(propertyName, operator, number) #Output: Text Issueslist


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 'called maximumNumberOfTryOuts ' is bigger than 3, e.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 'called numberOfLevels' is equal to 5, e.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
titletext

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
titlePROJECT LISTtext list
.


Include Page
DECADIS:_snip_limit_JQL_functions
DECADIS:_snip_limit_JQL_functions



Page properties
hiddentrue


Short description
JQL function to search for

Returns projects with specific numeric properties.

Output

Status
subtletrue
title

PROJECT LIST

text list

Label

Status
colourRed
titlestaff pick




Page properties
hiddentrue



Status
Tech review

Status
colourGreenYellow
titledoneReady for review

Style guide

Status
colourGreen
titledone

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