Loading TOC...
XQuery op:except

MarkLogic Server 11.0 Product Documentation
AccessPlan.prototype.except

AccessPlan.prototype.except(
   rightPlan as String
) as Plan

Summary

This method restricts the left row set to rows where a row with the same columns and values doesn't exist in the right row set.

Parameters
rightPlan The row set from the right view.

Usage Notes

except is a method of the following classes:

Example

const op = require('/MarkLogic/optic');

const tab1 = op.fromLiterals([
	              {id:1, val:'a'},
	              {id:2, val:'b'},
	              {id:3, val:'c'}
	              ]);
const tab2 = op.fromLiterals([
	              {id:1, val:'x'},
	              {id:2, val:'b'},
  	              {id:4, val:'n'},
	              {id:3, val:'c'}
	              ]);

tab2.except(tab1)
       .orderBy('id')
       .result();

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.