MarkLogic Server 11.0 Product Documentation

op.fromLexicons

op.fromLexicons(
   indexdef as String,
   [qualifier as String],
   [systemCols as String]
) as AccessPlan

Summary

This function dynamically constructs a view from range indexes or the uri or collection lexicons. This function will only return rows for documents where the first column has a value. The keys in the map specify the names of the columns and the values in the map provide cts.reference objects to specify the lexicon providing the values of the columns. Optic emits rows based on co-occurrence of lexicon values within the same document similar to cts.valueTuples If the cts.reference sets the nullable option to true, the column is optional in the row.

This function creates a row set without a limit. Use prototype.limit or prototype.offsetLimit to set a limit.

Usage Notes

The fromLexicons function is one of the Data Access Functions.

Example

// Return the EmployeeID, FirstName, LastName, the URI of the document
// holding the data, and document fragment ID for each employee with
// 'Manager' in their Position title.

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

const Plan =
op.fromLexicons({
            EmployeeID: cts.elementReference(xs.QName('EmployeeID')),
            FirstName: cts.elementReference(xs.QName('FirstName')),
            LastName: cts.elementReference(xs.QName('LastName')),
            URI: cts.uriReference()},
            null,
            op.fragmentIdCol('Document Fragment'));

Plan.result();