MongoDB query with projection without nested field that has no fixed parent name

user_10588848 0
Viewed 327

I'm trying to retrieve some documents from MongoDB through a query using projection.

The document looks something like this:

{
    "_id": "01",
    "country": "EUA",
    "created": "2020-09-10T18:12:20.649Z",
    "products": {
        "0001": {
            "id": "0001",
            "price": "1.25",
            "timestamp": "16004443546",
            "class": "com.website.ecommerce.src.main.java.model.product"
        },
        "0123": {
            "id": "0123",
            "price": "1.50",
            "timestamp": "16004443546",
            "class": "com.website.ecommerce.src.main.java.model.product"
        },
        "0443": {
            "id": "00443",
            "price": "1.75",
            "timestamp": "16004443546",
            "class": "com.website.ecommerce.src.main.java.model.product"
        }
    }
}

I don't need the "class" field to be retrieved, so given a query with 10k+ results, this field represents a big part of the response size.

collection.find({'_id': some_id}, {'products.*._class': 0 })

My guess is that there's some kind of wildcard character will do the job, but I'm unabled to find.

I tried: , $, $, $**, ** but no success.

mongodb nosql python
1 Answers
//actual code output from mongoshell 4.2.6 on windows
//prepare the document in a collection called eua, as given in problem statement
> db.eua.find().pretty();
{
        "_id" : "01",
        "country" : "EUA",
        "created" : "2020-09-10T18:12:20.649Z",
        "products" : {
                "0001" : {
                        "id" : "0001",
                        "price" : "1.25",
                        "timestamp" : "16004443546",
                        "class" : "com.website.ecommerce.src.main.java.model.product"
                },
                "0123" : {
                        "id" : "0123",
                        "price" : "1.50",
                        "timestamp" : "16004443546",
                        "class" : "com.website.ecommerce.src.main.java.model.product"
                },
                "0443" : {
                        "id" : "00443",
                        "price" : "1.75",
                        "timestamp" : "16004443546",
                        "class" : "com.website.ecommerce.src.main.java.model.product"
                }
        }
}
//use aggreate project command to first convert object to array in first stage
// use the project in 2nd stage to hide the class field
// reconvert back to original array to object with required fields marked as 1
> db.eua.aggregate([
...
... {
...     $project: {
...       _id: 1,
...       country: 1,
...       created: 1,
...       prodToArray: {
...         $objectToArray: "$products"
...       }
...     }
...   },
...   {
...     $project: {
...       "prodToArray.v.class": 0
...     }
...   },
...   {
...       $project:{
...           _id: 1,
...           country: 1,
...           created: 1,
...           products:{
...               $arrayToObject:"$prodToArray"
...           }
...       }
...   }
... ]).pretty()
{
        "_id" : "01",
        "country" : "EUA",
        "created" : "2020-09-10T18:12:20.649Z",
        "products" : {
                "0001" : {
                        "id" : "0001",
                        "price" : "1.25",
                        "timestamp" : "16004443546"
                },
                "0123" : {
                        "id" : "0123",
                        "price" : "1.50",
                        "timestamp" : "16004443546"
                },
                "0443" : {
                        "id" : "00443",
                        "price" : "1.75",
                        "timestamp" : "16004443546"
                }
        }
}
>
user_141485600
Related