GETPROPERTY
Use GETPROPERTY to return values from an XML variable. Multiple values are set with the SETPROPERTY function, which stores them as XML.
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
GETPROPERTY("XML_properties","key","property")
The first argument of the formula can be an object or string.
Example
=GETPROPERTY(reportvariables.rv_setproperty.text,"[Product]", "unique").In the Accessories pane you can see the XML definition of variables set with the SETPROPERTY function.
Select the variable and click the adjacent browse button.
GETPROPERTY is a list function. It can be used in server lists, relational lists, and in slices.
There are further key and property functions for retrieving values and properties from an XML variable.