op.case

op.case(
   whenExpression as String,
   valueExpression as String
) as valueExpression

Summary

This function returns the specified valueExpression if the specified valueExpression is true. Otherwise, it returns null.

Parameters
whenExpression	One or more op.when expressions.
valueExpression	The value expression to return if none of the op.when expressions is `true`.

Example

const op = require('/MarkLogic/optic');
const employees = op.fromView('main', 'employees');

employees.select(['EmployeeID', op.as('cased', op.case([
                   op.when(op.eq(op.col('EmployeeID'), 2), 'second'),
                   op.when(op.eq(op.col('EmployeeID'), 3), 'third')],
                   'otherwise'))])
          .result();