Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

XMLVALUES(<XPath>;<string [containing XML elements]>)

Description

Returns the values selected by the given XPath expression out of an XML document.

Example

Using XPath: /issues/issue/id/text()

XMLVALUES("/issues/issue/id/text()";#Column_with_XML)

Column with XMLXMLVALUES returns
<issues> <issue> <id>1</id> <name>Fix problem 1</name> </issue> <issue> <id>2</id> <name>Fix problem 2</name> </issue> </issues>[1, 2]
<issues> <issue> <id>3</id> <name>Fix problem 3</name> </issue> <issue> <id>4</id> <name>Fix problem 4</name> </issue> <issue> <id>5</id> <name>Fix problem 5</name> </issue> </issues>[3, 4, 5]
<issues> <issue> <id>6</id> <name>Fix problem 6</name> </issue> <issue> <id>7</id> <name>Fix problem 7</name> </issue> </issues>[6, 7]



  • No labels