...
The createdAt, modifiedAt, and _id are always returned in the collection.
| Code Block |
|---|
{
"$and": [{
"version "status": "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 = [ ]
...
| Code Block |
|---|
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.
...
| Code Block |
|---|
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/
...
| Code Block |
|---|
{
"$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.
...