I've been trying to flatten a field of array that occasionally has a nested array when its size is 1 as you can see in example below. (This happened due to a previous error I made with updateMany() while trying…
I am trying to apply the filter based on date in aggregation pipeline of mongo. See the aggregation pipeline below : var projectQry = [ { $match: { "prmid": userId } }, { "$unwind": { path : '$performanceData' } },…
I need to a match aggregation query for this sample schema { "items": [ {name:'Test1'},{name: null} ] } Query1: get documents if all name is null or unassigned Query2: get documents if at least 1 name is filled I tried…
Can you guys help me with this problem? Example: Data: { _id: "63f69650e820990f82dca60b", ..., transactions: [ { ..., fee: "100", ... }, { ..., fee: "200", ... } ] } I want to add a total_fee field to calculate total…
How can I get the List of Debit or Credit transactions Only. Like I have a column in my database , 2 columns actually. I want to be able to query for Debit transactions or Credit , The endpoint is…
There are a lot of errors in my application console. How to fix it? Next js 13.2 / app directory Import trace for requested module: ./node_modules/@aws-sdk/util-user-agent-node/dist-cjs/is-crt-available.js ./node_modules/@aws-sdk/util-user-agent-node/dist-cjs/index.js ./node_modules/@aws-sdk/client-cognito-identity/dist-cjs/runtimeConfig.js ./node_modules/@aws-sdk/client-cognito-identity/dist-cjs/CognitoIdentityClient.js ./node_modules/@aws-sdk/client-cognito-identity/dist-cjs/index.js ./node_modules/@aws-sdk/credential-providers/dist-cjs/fromCognitoIdentity.js ./node_modules/@aws-sdk/credential-providers/dist-cjs/index.js ./node_modules/mongoose/node_modules/mongodb/lib/deps.js ./node_modules/mongoose/node_modules/mongodb/lib/index.js ./node_modules/mongoose/lib/index.js ./node_modules/mongoose/index.js ./Total/db/connect.js ./Part/ssr/Ssr.js ./app/(pages)/profile/page.js ./node_modules/mongoose/node_modules/mongodb/lib/bson.js…
I want to pass the user data I fetched from a MongoDB database using the user id to the props in the return section. how can I send the data docs in the callback function to the props correctly? Thanks…
I have a MongoDb database with around 1000 records, I had the timestamp option set to false and none of them has the createdAt and updatedAt attributes. Now i've set the timestamp to true and I want to update all…
I have 2 collections, a parent and a child collection. The parent knows which children are linked. The parent: { _id: ObejctId; linkedChildren: ObjectId[] } I now wanna find the most efficient way, to find the children which are not…
I am using this code in MongoDB aggregation: { date: ISODate() } It's generating current date in ISO format for every document. How can I generate random ISO date for every document?