MarkLogic 9 Product Documentation

op:union

op:union(
   $leftPlan as map:map,
   $rightPlan as map:map
) as map:map

Summary

This method yields all of the rows from the input row sets. Columns that are present only in some input row sets effectively have a null value in the rows from the other row sets.

This method is often followed by the op:where-distinct modifier.

Example

import module namespace op="http://marklogic.com/optic"
     at "/MarkLogic/optic.xqy";

let $employees := op:from-view("main", "employees")
let $expenses  := op:from-view("main", "expenses")
 
return $employees             
   => op:union($expenses) 
   => op:where-distinct() 
   => op:order-by(op:view-col("employees", "EmployeeID")) 
   => op:result()