I'm making an aggregation and making 3 $lookup in 3 differents collections to get a collection where the location is . The problem is : I cant do a $geoNear after the first stage of the pipeline. So I tried…
I have this data and I want to sort it by two fields: first by specific address (details.address), for example 'Tel Aviv'. second by regular sort, by details.cost field. here is my data: [{ "_id": "123", "details": [{ "_id": "1",…
I have the following documents: _id: "Team 1" count: 1200 _id: "Team 2" count: 1170 _id: "Team 3" count: 1006 _id: "Team 4" count: 932 _id: "Team 5" count: 931 _id: "Team 6" count: 899 _id: "Team 7" count: 895…
I have a collection called "Image", below is 1 document of the Image collection: { "_id" : ObjectId("6234342df8afb4001e279ecc"), "is_deleted" : false, "labels" : [ { "_id" : ObjectId("623d687e745109001e09f146"), "labelId" : ObjectId("623d6821745109001e09f04e"), "xmin" : 0.400763358778626, "xmax" : 0.614503816793893, "ymin" : 0.694300518134715,…
Inspired by another question, suppose I have documents that contain an array of events, where each event has 3 fields: eventName, actorId, and detail: { _id: ObjectId("5a934e000102030405000000"), date: ISODate("2022-06-03T00:00:00.000Z"), events: [ { eventName: "Add", actorId: "1", detail: "new actor" },…
I am new to MongoDB aggregations and I am scratching my head on how to do something similar to this with Mongo: Example SQL Query (if this was a relational DB): select id, name, (select max(createdAt) from events where user_id=u.id)…
My documents look like this { "_id": { "$oid": "62825f71005ce00c5f0235c1" }, "user": "jon", "roles": { "User": 2001, }, "STOCK ": [ { "sku": "BLACK-M", "productname": "BLACK", "sendout": 0, "recived": 1, "totalinstock": 40, "location": "B32", "_id": { "$oid": "62826016005ce00c5f0235c8" } },…
I have a collection: public class Person { private String name; private Integer age; } I want to delete field age in all the documents. So the schema gonna look like that: public class Person { private String name; }…
// Product const ProductSchema = new Schema<TProductModel>( { name: String, } { timestamps: true } ); // OrderDetails const OrderDetailsSchema = new Schema<TOrderDetailsModel>({ product: { type: Schema.Types.ObjectId, ref: 'Product' }, productsInOrder: { type: Number, default: 1 }, orderLimit: Number, orderId:…
I have several documents, I want to remove the alphabet from the data field, based on the 1st _ in the data field, please see the following output. and if the data is empty the get message "Not Auto found".…