MarkLogic 12 Product Documentation

op.jsonNull

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

const literals = op.fromLiterals([
            {row:1, gp: 1, nm:"alpha", str:"a", num:10, bool:true},
            {row:2, gp: 1, nm:"beta", str:"b", num:20, bool:false},
            {row:3, gp: 2, nm:"gamma", str:"c", num:30, bool:true},
            {row:4, gp: 2, nm:"delta", str:"d", num:40, bool:false}
	          ])
literals.where(op.eq(op.col('gp'), 1))
	      .select(['row',
	               op.as('node', op.jsonArray([
	                 op.jsonString(op.col('str')),
                     op.jsonNumber(op.col('num')),
                     op.jsonBoolean(op.col('bool')),
                     op.jsonNull()
	                ])),
	                op.as('kind', op.xdmp.nodeKind(op.col('node')))
	             ])
	      .orderBy('row')
          .result();