GETPROPERTYVALUES
This function returns a list of all the properties of a specified value from an xml variable. It returns a string.. It is similar to GETPROPERTYVALUESA, which returns the properties as an array.
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
GETPROPERTYVALUES("XML_properties","property","separator")
Example
=GETPROPERTYVALUES(ReportVarialbles._rv_xmlvariable.text, "Unique_Name",",")Note: In GETPROPERTYVALUES, the
.text attribute is optional.
In GETPROPERTYVALUESA, the .text
attribute is required. GETPROPERTYVALUES is a list function. It can be used in server lists, relational lists, and in slices.