MarkLogic 10 Product Documentationop:not-exists-join
op:not-exists-join( $leftPlan as map:map, $rightPlan as map:map, [$keys as map:map*], [$condition as map:map?] ) as map:map
Summary
This method is a filtering join that filters based on whether the join exists or not but doesn't add any columns.
It filters the left row set to the rows that don't have a join in the right row set.
| Parameters | |
|---|---|
| $leftPlan | The row set from the left view. |
| $rightPlan | The row set from the right view. |
| $keys | The equijoin from one or more calls to the op:on function. |
| $condition | A boolean expression that filters the join output rows. |
Example
(: It filters out {'r1':2, 'k1':'b'} in p1 as value 'b' doesn't exist in column 'k2' of p2 :)
xquery version "1.0-ml";
import module namespace op="http://marklogic.com/optic"
at "/MarkLogic/optic.xqy";
op:from-literals((
map:entry("r1", 1) => map:with("k1", "a"),
map:entry("r1", 2) => map:with("k1", "b")
))
=> op:not-exists-join(
op:from-literals((
map:entry("r2", 3) => map:with("k2", "a"),
map:entry("r2", 4) => map:with("k2", "c")
)),
op:on("k1", "k2")
)
=> op:result()
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.