GETPROPERTIESA
Returns, as an array, from an xml variable, a list of the properties of a specified key. It is similar to GETPROPERTIES, which returns the properties as a string.
See GETPROPERTIES.
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
GETPROPERTIESA("String xml definition","[Key]")#ARRAY is displayed in cells that contain arrays.
Example
=GETPROPERTIESA(ReportVariables.rv_xmlvariable.text,"[Product]")
Note: In GETPROPERTIESA, the .text attribute is required. In
GETPROPERTIES, the .text attribute is optional.
GETPROPERTIESA can be used in formulas in server lists.
Related topics