Matches for cat:function (cat:function/javascript (cat:function/javascript)) have been highlighted.
MarkLogic 12 Product Documentationop.col
op.col( colName as String ) as columnIdentifier
Summary
Identifies a column where the column name is unique and a qualifier on the column name isn't necessary (and might not exist).
In positions where only a column name can appear, the unqualified column name can also be provided as a string. Qualified column names cannot be provided as a string.
The returned value from this function can be modified by any of the functions described in Expression Functions For Processing Column Values in the Application Developer's Guide
| Parameters | |
|---|---|
| colName | The name of the column. |
Example
// Calculate the total expenses for each employee and return results in order of employee number.
const op = require('/MarkLogic/optic');
const employees = op.fromView('main', 'employees');
const expenses = op.fromView('main', 'expenses');
const totalexpenses = op.col('totalexpenses');
const Plan =
employees.joinInner(expenses, op.on(employees.col('EmployeeID'), expenses.col('EmployeeID')))
.groupBy(employees.col('EmployeeID'), ['FirstName', 'LastName', expenses.col('Category'),
op.sum(totalexpenses, expenses.col('Amount'))])
.orderBy('EmployeeID')
Plan.result();
Example
// Rows with a EmployeeID greater than 3
const op = require('/MarkLogic/optic');
const employees = op.fromView('main', 'employees');
const Plan =
op:where(op:gt(op:col('EmployeeID'),3))
Plan.result();
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.