MarkLogic 12 Product Documentationop.columnBuilder
op.columnBuilder() as ColumnBuilderPlan
Summary
Create column definitions which can be used in op.fromDocs . Below functions are used to create column definitions. ColumnBuilderPlan.prototype.addColumn , ColumnBuilderPlan.prototype.type , ColumnBuilderPlan.prototype.xpath , ColumnBuilderPlan.prototype.expr , ColumnBuilderPlan.prototype.nullable , ColumnBuilderPlan.prototype.default , ColumnBuilderPlan.prototype.dimension , ColumnBuilderPlan.prototype.coordinateSystem , ColumnBuilderPlan.prototype.units , ColumnBuilderPlan.prototype.collation .
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()
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.