Server-side JavaScript

Update

Update complete JSON documents by reading them from the database, converting them to JavaScript objects (Using .toObject()), and re-inserting them at their same URIs. It’s important to note that JSON nodes are immutable. That is, you cannot directly change a JSON node.

// Tell the transaction manager that we're about to make an update
declareUpdate();    

// For each item in the collection, update the balance field from a string
//   balance: "$1,234.56" 
// to a Number representing the value and a unit of measure 
//   balance: { value: 1234.56, unit: "USD" }    
for (var item of fn.collection("fake data")) {
  // Turn the JSON node from the database into a JavaScript object so we can 
  // update it. JSON nodes are immutable.
  var obj = item.toObject();
  if (obj.balance && !obj.balance.value) {
    obj.balance = { 
      value: parseFloat(obj.balance.replace(/[$,]/g, "")),
      unit: "USD"
    };
    
    // Get the existing metadata on the document 
    var uri = xdmp.nodeUri(item);
    var permissions = xdmp.documentGetPermissions(uri);
    var collections = xdmp.documentGetCollections(uri);
    // Re-insert with the same URI
    xdmp.documentInsert(uri, obj, permissions, collections);
  }
}

Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.

Contents

Server-side JavaScript

Update