Loading TOC...

MarkLogic 12 Product Documentation
ColumnBuilderPlan.prototype.type

ColumnBuilderPlan.prototype.type(
   type as String
) as ColumnBuilderPlan

Summary

Set the data type of the column created by ColumnBuilderPlan.prototype.addColumn .

Parameters
type The type of the column to be defined. The supported data types are the same as those used for the scalar-type property in TDE. In addition, the special type node is supported.

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 iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.