GETKEYVALUES
Returns a list of all the values of a specified key from an xml variable. It is similar to the GETKEYVALUESA function, which returns the values as an array.
SeeGETKEYVALUESA.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
GETKEYVALUES("String xml definition","[KEY]","separator")
Syntax
Example
=GETKEYVALUES(ReportVariables.rv_xmlvariable.text,"[Product]",",")
Note: In GETKEYVALUES, the .text attribute is optional. In
GETKEYVALUESA, the .text attribute is required.
GETKEYVALUES can be used in formulas in server lists.
Related topics