GETKEYVALUES

Returns a list of all the values of a specified key from an xml variable. It is similar to the GETKEYVALUESA function, which returns the values as an array.

SeeGETKEYVALUESA.You can specify the list separator to use.

You can use the asterisk (*) character at the beginning or end of a string as a wildcard. For example, to return particular keys or properties. Asterisks within a string do not act as wildcards. A wildcard search returns only the first matched key or property.
Note: We cannot guarantee the order in which keys or properties are matched.

Syntax

GETKEYVALUES("String xml definition","[KEY]","separator")
	 

Syntax

Example

=GETKEYVALUES(ReportVariables.rv_xmlvariable.text,"[Product]",",")
	 
Note: In GETKEYVALUES, the .text attribute is optional. In GETKEYVALUESA, the .text attribute is required.

GETKEYVALUES can be used in formulas in server lists.

Related topics