op.xpath( columndef as String, path as String ) as nodeValue
This function extracts a sequence of child nodes from a column with node values -- especially, the document nodes from a document join. The path is an XPath (specified as a string) to apply to each node to generate a sequence of nodes as an expression value.
Parameters | |
---|---|
columndef | The name of the column from which to extract the child nodes. |
path | An XPath (specified as a string) to apply to each node. |
const op = require('/MarkLogic/optic'); const literals = op.fromLiterals([ {id:1, val: 2, uri:"/employee1.json"}, {id:2, val: 4, uri:"/employee2.json"}, {id:3, val: 6, uri:"/employee3.json"}, {id:4, val: 8, uri:"/employee4.json"} ]) literals.orderBy('id') .joinDoc(op.col('doc'), op.col('uri')) .select(['id', 'val', 'uri', op.as('EmployeeID', op.xpath('doc', '/(Employee/ID|Expenses/EmployeeID)')) ]) .result();
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.