So I have 2 arrays here, let say const users = [{_id:ObjectId("6274fb5b82bcc9b2ccc0a361"), name:p1, age:10}, {_id:ObjectId("6274fbc382bcc9b2ccc0a362"), name:p2, age:15}, {_id:ObjectId("6277a3d5b66c061096222bbd")}, name:p3, age:20]; const filterArray = [ObjectId("6274fbc382bcc9b2ccc0a362"),ObjectId("6277a3d5b66c061096222bbd")]; I want to filter result based on matching ObjectId, here's what I'm trying to do const…
I have following document on which the update needs to be done. { "_id": "Colorcode_1", "Combination": [ { "color": [ { "mixture": [ "Red", "Green" ] } ], "code": "Maroon" }, { "color": [ { "mixture": [ "Yellow", "Green" ]…
In a jointed aggregation (with lookup), I'm trying to sum values of a key in the following "resa" field, groupped in a projection (see code snippet #2). Context: Here I'm trying to sum the amount of "adultCount" values for every…
I have a JSON file that includes data of daily covid cases of all the Canadian provinces(13), and I'm trying to transform the design to load it into MongoDB and get 13 collections of province documents with code and name…
I have an existing document and I wish to add a unique Object Id to each of the transaction Array Objects. { _id: ObjectId(6086d7e7e39add6a5220d0a5), firstName: "John" lastName: "Doe" transactions: [ { date: 2022-04-12T09:00:00.000+00:00 amount: 286.56 type: "deposit" method: "Bank transfer"…
const serverS = await server.findOne({ guildID: message.guild.id }); serverS.settings[1]["links"] = true; serverS.save() The code I use ^^^^ So when it saves the changes I check the database using MongoDB compass I don't see the change appearing in the array object…
I am working on a timeslot system that will give available time slots and unavailable but I am filtering available slots and loading the array. Sometimes many days don't have available timeslots. I wanted to find the next available slots…
I have a carousel which has to display two items per column in each item. I tried using foreach method and array_chunk() to do so, but it doesn't seem to do the work. This is the code I am working…
How can I extract all elements from this array through PHP? I tried to do with array_slice but it didn't help My main problem is that I need to derive all the meanings, not just the last ones. So that…
I am new to MongoDB and I'm struggling in extract a subdocument from a document. In my case, I have the following schema: [ { user_id: "u1", subscriptions: [ { "tier": "Basic", "requests": [ { "name": "aaaa" }, { "name":…