...
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.
...