I have a document as follows: { "_id": "1234", "created_at": 1678787680 } I want to modify the document and add a new key updated_at which will be a datetime equivalent of the created_at UNIX timestamp. { "_id": "1234", "created_at": 1678787680,…
How can I compare month in spring mongo criteria with a hard corded value, month in criteria is in a spring format and the value is present in an integer format. This is what i have so far i just…
I have a collection named employees with documents like. { first_name:"john", last_name:"doe" } I want to run an update query which adds a new field like {name:'john doe'} I know it can be done like this db.employees.find({}).forEach(doc=>db.employees.update({"_id":doc._id},{$set:{name:doc.first_name+"-"+doc.last_name}})) but its taking…
I have written a MongoDB query that looks like this: db.collection.aggregate([ { $group: { _id: null, categories: { $addToSet: "$category" } } }, { $project: { _id: 0, categories: 1 } } ]) but the result is: [ { "categories":…
I have a MongoDB Collection with objects of type: { id: 1223 items: [{ length: 12.233333, }, { length: 4.2323232323232, }] } How can I update the length of each item by rounding to 2 decimals.
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…
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?
Can you help me with a situation... I Have this Json but I would like to format the field trackingID like "TR000000012345BR". How can I pad a trackingId with letters and zeros on the left and letter on the rigth…
Trying to condense an array with key value pairs into an array of objects with the key and all the unique values for that key. I have a structure like: { fruits: [ {fruit: apple, type: gaja}, {fruit: apple, type:…