GETPROPERTYVALUESA

This function returns a list of all the properties of a specified value from an xml variable. The function returns an array. It is similar to GETPROPERTYVALUES, which returns the properties as a string.

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

GETPROPERTYVALUESA("XML_properties","property")

#ARRAY is displayed in cells that contain arrays.

Example

=GETPROPERTYVALUESA(ReportVariables.rv_xmlvariable.text, "Unique")

Note: In GETPROPERTYVALUESA, the .text attribute is required. In GETPROPERTYVALUES, the .text attribute is optional.

GETPROPERTYVALUESA is a list function. It can be used in server lists, relational lists, and in slices.