I will have to sort data by data and acccording to the pagination. This is the query which I used response.data = await distributorDoc.find().sort({"TimeStamp":-1,}); It is the pagination pagination: { totalCount: 0, pageCount: 0, currentPage: page, perPage: reqData.perPage || perPageCount…
Firstly, here is my "User" collection simplified down to only the relevant fields: [ { _id: "10", groups: [ "1" ], notifications: [ { notificationType: "message-like", msgId: "3", read: false, likers: ["steve", "joe"] } ] }, { _id: "20", groups:…
connection.once('open', () => {console.log('DB Connected!')}).catch((err) => { ^ TypeError: connection.once(...).catch is not a function This error are shows when server started I need help to solve this error
im trying to update data in mern stack application and i found that the formdata is empty and i wonder why ! i get all the value and pased them in function update to update the data and then i…
I am using NuxtJS 3 and Vue 3 and I am connecting to a single mongoDb database without problem. I would like to connect at the same time to another database, where I will store and retrieve data. My question…
I'm trying to add filter on populated data. "populate": [ { "path": "attachments", "select": "_id type", "match": { "type": { "$in": [ 2 ] } } } ] Data without filter [ { _id : "6e43454gvbnbvb7888", name: "T1", attachments :{…
How to delete the strings before the first occurrence, and after the last occurrence of the delimiter? The delimiter is an underscore "_". Sample data is: [ { "originalValue": "DELETERANDOMVALUE_Keep_This_Words_DELETERANDOMVALUE" } ] The expected result should be: [ { "cleanedValue":…
I am new to MongoDB. I have a VIEW created on a collection, I need to make a modification to this VIEW. Say we have a collection CollectionName. It has an array field aArray. This arrays has 2 fields, arrayField1…
Messing around with aggregations in MongoDB in a Node / Express app with Mongoose. Here's the route: router.get("/search", async (req, res) => { let movies; if(req.query.search){ escapeRegex(req.query.search); const regex = new RegExp(escapeRegex(req.query.search), 'gi'); movies = await Movie.aggregate( [ { '$match':…
I have a MongoDB collection containing documents like these: { "id": "62cd5de762c595905e37821b", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "name": "test", "family ": "test" } }, { "id": "62cd5de762c595905e37821a", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "type": "xxxx", "where": "test" } }…