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

Versions Compared

Old Version 4

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Jona Ittermann

Saved on

Key

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

Page properties
hiddentrue
Status
Tech review

Status
titletodo

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

UI Text Box
sizemedium
typeinfo

This function is used for searching text or string values in project properties JQL function returns projects with specific properties containing a text value.

Code Block
languagebash
titleSyntax
linenumberstrue
projectsWhereTextProperty( project_propertypropertyName, operator, string_literal | regular_expression value) #Output: ProjectText list
UI Expand
titleExamples
Parser expressionDescription
Code Block
languagebash
linenumberstrue
projects
project in projectsWhereTextProperty(
"country", "=", "Spain
")
This example returns a list of projects where the project property
'
country
'
is equal to
'
Spain
'
, i.e.
string
text {country=Spain} is present in the project's description.
Code Block
languagebash
linenumberstrue
project
projects
 in projectsWhereTextProperty(
"country", "matches", "France|Germany"
)
This example returns a list of projects where the project property
'
country
'
matches the regular expression France|Germany, i.e.
string
text {country=France} or {country=Germany} are present in the project description.
Code Block
languagebash
linenumberstrue
project
projects
 in projectsWhereTextProperty(
"country", "~", "spain
")
This example returns a list of projects where project property
'
country
'
is equal to
'
spain
'
,
'
SPAIN
'
,
'
SpAiN
'
, etc.
UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
project_property
propertyName

Status
subtletrue
titletext

The name of a project property containing a text
or string
string_literal | regular_expression
value.
operator

Status
subtletrue
title

data type

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.

value

Status
subtletrue
titletext

A string literal
The text value used for
comparison,
searching or a regular expression in the case of the matches operator.
UI Expand
titleOutput

This function returns a

Status
subtletrue
titletext list

Include Page
DECADIS:_snip_limit_JQL_functions
DECADIS:_snip_limit_JQL_functions

Page properties
hiddentrue
Short description

Returns projects with specific text properties.

Output

Status
subtletrue
title

Project list

text list

Label
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