GETPROPERTIES

Returns, as a string, from an xml variable, a list of the properties of a specified key. It is similar to GETPROPERTIESA.

See GETPROPERTIESA.

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

GETPROPERTIES("String xml definition","[Key]","separator")
	 

Example

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

GETPROPERTIES can be used in formulas in server lists.

Related topics