I am having issues with projecting some fields with mongodb $project my colection has the following datas [{num:"SI-0101",mob:6289141515},...] and my $project query [{ $project: { "Id No.": "$num", "Mobile No.": "$mob" // note on that ., i need it in…
I have a Mongo collection as such: db.items.find({}): [{ "_id": { "$oid": "64e929386a2bff904d86118a" }, "name": "Copies", "legacy_id": 181 }, { "_id": { "$oid": "64e929386a2bff904d86118b" }, "name": "Temp", "legacy_id": 182 }, { "_id": { "$oid": "64e929386a2bff904d86118c" }, "name": "Test", "legacy_id": 183…
I'm trying to find all unique strings of some subdocument in MongoDB, as long as at least one of them contains a certain substring. These strings are localized though. I want to have the results for all possible languages. So,…
Please refer the attached image and help me explain this case. Why didn't cova_items column assigned value of InStock column when woo_order_id is null? query command: db.cova_order.aggregate([ { $project:{ InStock:1, woo_order_id:1, woo_order_data:1, cova_items:{ $cond: { if: { $eq:["$woo_order_id",null] }, then:"$InStock"…
Our DB has hundreds of thousands of rows of data where a particular entity amasses points in a certain entry based on certain constraints. Let us call the entities A1, A2…A1000. Let the constraints be X1, X2, X3…Xn. The constraints…
I have the nested fields for many ingredients and would like to add all the corresponding fields nutrients: { vitaminB: { type: Number, default: 0, }, vitaminC: { type: Number, default: 0, }, //more I have the following code Ingredient.aggregate([…
I have a bunch of records in this format on mongodb [ {_id: 1, date:'2023-07-28',sales:1,ad_id:1,status: 'Active'}, {_id: 2 , date:'2023-07-29',sales:2,ad_id:1,status: 'Active'}, {_id: 3, date: '2023-07-30',sales: 4,ad_id:1,status: 'Paused'} ] Now if I want data from date 2023-07-28 to 2023-07-29 . I…
I'm developing a backend application using Apollo GraphQL and Mongoose. I have two models: User and Post, which have a one-to-many relationship (a user can have many posts, but a post belongs to one user). I want to query the…
How to query the "car" collection, which stores a document for every car, and retrieve all cars that include specific keywords in their names. Then, find the latest "carInfo" document for each of these cars and return only the cars…
I am using Ruby on Rails and I have the following Mongo collection, { _id: 1, name: "Jackie Chan", sn: "ABC123", Country: Australia }, { _id: 2, name: "Brad Pitt", sn: "ABC124", Country: Russia }, { _id: 3, name: "Al…