I have a document that looks something like this { "_id":{ "$oid":"id" }, "side1":[ { "username":"test1", "id":"id1", }, { "username":"test2", "id":"id2", }, { "username":"test3", "id":"id3", } ], "side2":[ { "username":"test4", "id":"id4", }, { "username":"test5", "id":"id5", }, { "username":"test6", "id":"id6", }…
I have this document : [ { "_id": "626c5fd2aa0fc0e4eef45c94", "productos": [ { "_id": "626d50b621180e291a330333", "nombre": "ciruelas", "descripcion": "marca lala", "codigo": 33, "foto": "https://cdn3.iconfinder.com/data/icons/fruits-52/150/icon_fruit_morango-256.png", "precio": 15, "stock": 30, "timestamp": "2022-04-30T15:06:45.128Z", "__v": 0 } ], "timestamp": "2022-04-29T21:59:35.301Z", "__v": 0 }, { "_id":…
I am just wondering if its possible to use a $lookup aggregation operator inside of the in field of a $map operator. I am trying to map the VINs inside the carData objects to corresponding document ids in a VIN…
I have a restAPI which allows for users to submit data to be saved in my database. When data is submitted their userID will be grabbed from the request header and added to the document In my collection (mongoDB) there…
Here's my schema { _id : Number, user1: { _id : Number, userDetail : { userId : Number, userResult : String, } }, user2 : { _id : Number, userDetail : { userId : Number, userResult : String, } },…
I want to get object like this: [ { label: "first", id: 1, children: [] }, { label: "second", id: 2, children: [ { label: "third", id: 3, children: [ { label: "fifth", id: 5, children: [] }, { label:…
what is the best way to clean xcom table in airflow? thats running in docker with postgres db. i've try to delete some data with query (Delete from xcom) and try running this reference: https://cloud.google.com/composer/docs/cleanup-airflow-database but it doesn't work, xcom…
i m trying to build a sortable drag and drop list and the order must change everytime i drop the element in the his new area i m using ajax and laravel but when i drop the element i got…
I'm working with this query: customers.aggregate: [ {$lookup: { from: "users", localField: "_id", foreignField: "customerId", as: "users" }}, {$lookup: { from: "templates", let: {localField: "$_id"}, pipeline: [{ $match: { $and: [{ $expr: { $eq: ["$customerId", "$$localField"]}}, {module: false}] }}], as:…
I am trying to link two tables in mongo db. I have a User table where user has an _id. And a News table where the columns should be _id(for the news) and the userId (to link news to a…