MarkLogic 12 Product Documentation

ModifyPlan.prototype.whereDistinct

ModifyPlan.prototype.whereDistinct() as ModifyPlan

Summary

This method removes duplicate rows from the row set.

Usage Notes

whereDistinct is a method of the following classes:

• AccessPlan
• ModifyPlan

Example

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

op.fromLiterals([
            {id:1, val: 2},
            {id:1, val: 2},
            {id:2, val: 4}
	        ])
   .select()
   .whereDistinct()
   .result();