GETKEYVALUESA

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

See GETKEYVALUES.

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

GETKEYVALUESA("String xml definition","[KEY]")
	 
#ARRAY is displayed in cells that contain arrays.

Example

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

GETKEYVALUESA can be used in formulas in server lists.

Related topics