Loading TOC...
XQuery op:case

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();

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.