MarkLogic 12 EA 2 Product Documentation

AccessPlan.prototype.joinCrossProduct

AccessPlan.prototype.joinCrossProduct(
   rightPlan as String,
   [condition as xs.boolean]
) as ModifyPlan

Summary

This method yields one output row set that concatenates every left row with every right row. Matches other than equality matches (for instance, greater-than comparisons between keys) can be implemented with a condition on the cross product.

The join performs natural joins between columns with the same identifiers. To prevent inadvertent natural joins, specify a different qualifier for the left or right columns or use different column names for the left and right columns.

Usage Notes

joinCrossProduct is a method of the following classes:

• AccessPlan
• ModifyPlan

Example

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

const employees = op.fromView('main', 'employees');
const expenses = op.fromView('main', 'expenses');

const Plan =
    employees.joinCrossProduct(expenses)
             .where(op.eq(employees.col('EmployeeID'), expenses.col('EmployeeID')))
             .orderBy([employees.col('EmployeeID')])
    Plan.result();