GETKEY

This function returns the first occurrence of a specified key from an xml variable.

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

=GETKEY("XML_properties","key")

Example

Report variable rv_example has this XML content:

<Table><Row name="[Product]"><Property name="Unique" value="[Product].[All Tires].[Car Tires All Season]" /></Row></Table>

This syntax returns the [Product] key from the variable:

=GETKEYS(reportvariables.rv_example.text,"[P*")