Delete object inside array in collection mongo db [duplicate]

Question

I have a collection name dbapp in my mongodb. There is a document as follows,I want to remove on widget object inside widgets.I am troubling to create mongodb command script for that.Apprciate your help.thanks

  db.dbapp.insert(
    {
        "tenantid": 16,
        "id": 0,
        "default": true,
        "widgets": [
            {
                "_id": new ObjectId(),
                "position": 1,
                "type": 1,
                "class": "green",
                "metricid": 5
            },
            {
                "_id": new ObjectId(),
                "position": 2,
                "type": 1,
                "class": "blue",
                "metricid": 6
            },
            {
                "_id": new ObjectId(),
                "position": 3,
                "type": 2,
                "class": "normal",
                "metricid": 1
            },
            {
                "_id": new ObjectId(),
                "position": 4,
                "type": 2,
                "class": "normal",
                "metricid": 2
            },
            {
                "_id": new ObjectId(),
                "position": 5,
                "type": 2,
                "class": "normal",
                "metricid": 3
            }
        ],
        "settings": {
            "appid": 0,
            "appname": "default"
        }
    });

bappr · Accepted Answer · 2017-05-17 11:22:56Z

-1

You may want to use the operator $pull. https://docs.mongodb.com/manual/reference/operator/update/pull/

For example:

db.dbapp.update(
    { "id": 0 },
    { $pull: { widgets: { position: 1 } } }
)

will remove the first widget

edited May 17, 2017 at 11:22

answered May 17, 2017 at 11:11

bappr

3254 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Delete object inside array in collection mongo db [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related