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

Supported list types

Number list

This function returns the numeric reference value 

Syntax
getMatchingValue(key, keyList, referenceList) #Output: number
Examples
Parser expressionDescription
getMatchingValue("Three", ["One", "Two", "Three", "Four", "Five"], [1, 1+1, 3*1, 4, 4+1])

This example returns the number: 3

getMatchingValue("Critical", ["Normal", "High", "Critical"], [1, 5, 20])
This example returns the number: 20
Additional information

Parameters used in this function

ParameterInput (data type)Description
key

TEXT

A text that exists in the keyList.
keyList

TEXT LIST

Any given text list.
referenceList

NUMBER LIST

Any given number list.
Output

This function returns a NUMBER .

If the key is not in the keyList, the function returns NULL.


Variant with 2 number lists.

Syntax
getMatchingValue(key, keyList, referenceList) #Output: Number
Examples
Parser expressionDescription
getMatchingValue(5, [1, 3, 5, 7, 9], [1, 1+1, 3*1, 4, 4+1])

This example returns the number: 3

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
Output

This function returns a NUMBER


Text list

This function returns a text value in value_list that is in the same position as text key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then, the element of value_list in position count(key_list) + 1 .

Syntax
getMatchingValue(string key, string list key_list, string list value_list)#Output: Text
Examples
Parser expressionDescription
getMatchingValue("Spain", ["USA", "UK", "France", "Spain", "Germany"], ["Washington", "London", "Paris", "Madrid", "Berlin"])

This example returns the following text: "Madrid"

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
Output

This function returns a TEXT


Variant where argument key is a number and argument key_list is a number list.

Syntax
getMatchingValue(number key, number list key_list, string list value_list) #Output: Text
Examples
Parser expressionDescription
getMatchingValue(8, [2, 4, 6, 8, 10], ["Washington", "London", "Paris", "Madrid", "Berlin"])

This example returns the following text: "Madrid"

Additional information

Parameters used in this function

ParameterInput (data type)Description
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
xxx

DATA TYPE

Parameter description.
Output

This function returns a TEXT