MarkLogic 12 Product Documentation
ColumnBuilderPlan.prototype.nullable

ColumnBuilderPlan.prototype.nullable(
   bool as Boolean
) as ColumnBuilderPlan

Summary

Set the column created by ColumnBuilderPlan.prototype.addColumn nullable or not.

Parameters
bool Marks a column as nullable or not. True or false.

Example

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

op.fromDocs(
  cts.collectionQuery("fromDocsJson"),
  "/",
  op.columnBuilder()
   .addColumn("id").nullable(true).type("integer").default(-1)
   .addColumn("name").collation("http://marklogic.com/collation/codepoint")
   .addColumn("node").type("node").xpath(".")
   .addColumn("expr").type("unsignedLong").expr(op.xdmp.random())
   .addColumn("vector").type("vector").dimension(3)
   .addColumn("geoData").xpath("geo").type("point").coordinateSystem("wgs84/double").units("miles"),
 "myView", "myFragmentId"
)
.orderBy("id")
.select(["id","name","node","expr","vector","geoData","myFragmentId"])
.result()
  
Powered by MarkLogic Server | Terms of Use | Privacy Policy