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