op.isDefined

op.isDefined(
   booleanExpression as xs.boolean
) as booleanExpression

Summary

This function tests whether the value of an expression is null in the row where the expression might be as simple as a column identified by op.col .

Parameters
booleanExpression A boolean expression that might be null. See Boolean Expression Functions for the list of functions used to build boolean expressions.

Example

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

op.fromLiterals([
	            {row:1, sparse:6},
	            {row:2},
	            {row:3, sparse:4}
	            ])
	          .select(['row', 'sparse',
	              op.as('defcheck', op.sem.if(op.isDefined(op.col('sparse')), 'present', 'absent'))
	              ])
	          .result();
  
Powered by MarkLogic Server | Terms of Use | Privacy Policy