Dynamic Data Manager node lets you manage the data that you want to store.

...

...

Table of Contents
exclude Related

Model

You can choose the schema from this drop-down.

...

The createdAt, modifiedAt, and _id are always returned in the collection.

{ 
"$and": [{ 
        "versionstatus": "1",
  Inactive" 
    }, 
    { 
        "age":{ "$gte":"32" } 
    }],
"createdAt": { "$gt" : "{{msg.startDate}}" },
 
"limit": 999,
 
"page": "{{msg.pagePntr}}",
 
"sortBy": {"createdAt":-1}
} 

The In the init function node, set up the pagePntr to start at 1. A common mistake is to start at 0.
Also setting up the array to store the results, in this case, msg.userDataArray = [ ]

...

msg.pagePntr = 1;  // init page pointer to 1
msg.userDataArray = [];  // init aray
var moment = global.get('moment');
const now = moment();  // use moment to creat time 20 days earlier than today
const DaysAgo = now.subtract(20, "days").startOf("day").utc().toISOString();
node.warn(DaysAgo); 
// "2020-11-16T00:00:00.000Z"
msg.startDate = DaysAgo;
return msg;

The loop function node concatenates the results of each page until it collects all the data.

...

var userData = msg.data.dynamicData.result;  // Get the results from dynamic data node.
if (userData.length > 0) {   // is there any data.
    msg.userDataArray = msg.userDataArray.concat(userData);  // append to the last array.
    msg.pagePntr = parseInt(msg.pagePntr) + 1;  // increment the page pointer.
   // node.warn('Next page ' + msg.pagePntr);
    if(msg.data.dynamicData.paging.hasMore.hasNext === false) {   // is there another page. if not exit loop
       return [null,msg]    
    } else {
        return [msg,null]  // get the next page of data.
    }
} else {
    return [null,msg]   // no data
}

...

Example 2

This example deals with the Read, OR condition, AND, NOT Equal.

You can get more query commands at https://docs.mongodb.com/manual/tutorial/query-documents/

...

{
"$or": [{"runStatus": "start"}, {"acknowledge": "yes"}],    
  "runStatus": { "$ne": "Complete" },
"limit": 900,
"page": 1,
"sortBy": {"createdAt":-1}
} 

Create

Lets you create a new data item. If you don’t specify a project ID in the payload, the data is created as Global data.

...

If the field is available in the schema, you can update the content of that field will be updated with the content given in using the payload. The _id is used to identify the data item (required item). The field that you want to update must be inside the data object.

For example,

Example 1

You can update the field value of hospitalCounty field in the following image, hospitalCounty is a field the schema using the below code.

{
    "_id" : "61362fff4f3c310078f92dad",
    "data":{
        "hospitalCounty": "county"
    }
}

In the below image, a field name hospitalCounty is available in the schema and that will be updated with the data value “county”.

...

Example 2

In this example user, each record has a unique id called a token, only one result will be returned and we are going to update the runStatus to Complete

...

Example 3

In this example, we will use the function node to construct the entire payload and content to be updated and push it to the Dynamic data manager node.

Consider the schema with the Boolean and Datetime fields and you wanted to format the datetime field before updating it.

Use the function node to format the date time and construct the msg.payload.data property as shown below.

const moment = global.get("moment");
var currentTime = moment().format('LLLL')
msg.payload.data = {
    "_id" : "61362fff4f3c310078f92dad",
    "data":{
        "isActive": true,
        "lastContactedDate":currentTime
    }
};
return msg;

The _id property uniquely identifies the document and the data object contains the schema fields to be updated.

Update the Model and Action (update). Leave the Dynamic data manager node’s payload field empty as we have constructed the payload object in the function node.

...

Upsert

If multiple results are found for a query, the oldest data item gets updated.

...