GETKEYS

Returns a list of all keys from an xml variable. it is similar to the GETKEYSA function, which returns the keys as an array.

SeeGETKEYSA.

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

=GETKEYS("String xml definition","separator")
	 

Example

=GETKEYS(ReportVariables.rv_xmlvariable.text,",")
	 
Note: In GETKEYS, the .text attribute is optional. In GETKEYSA, the .text attribute is required.

GETKEYS can be used in formulas in server lists.

Related topics