mongoose remove an object from a nested array

Question

I am trying to find an update a document using mongoose, by removing an object from a nested array. My target document is the following:

user = {
    "userId" : "myId",
    "connections":
    [{
        "dateConnectedUnix": 1334567891,
        "isActive": true,
        "sessions": [
            {"device": "mobile", "country": "US"},
            {"device": "desktop", "country": "US"}
        ]
    }, {
        "dateConnectedUnix": 1334567893,
        "isActive": false,
        "sessions": [
            {"device": "mobile", "country": "CA"},
            {"device": "desktop", "country": "CA"}
        ]
    }]
}

here is my attempt, but it is not updating the document:

Users.findOneAndUpdate({ "userId": "myId", "connections.dateConnectedUnix": 1334567891 },
    { $pull: { sessions: { device: "mobile" } } }, (err) => {
        if (err) {
            return res.status(404).json({ message: 'Error' });
        }
        return res.status(200).json({
            success: true,
            message: 'success'
        });
    }
);

the resulting document should look like:

user = {
    "userId" : "myId",
    "connections":
    [{
        "dateConnectedUnix": 1334567891,
        "isActive": true,
        "sessions": [
            {"device": "desktop", "country": "US"}
        ]
    }, {
        "dateConnectedUnix": 1334567893,
        "isActive": false,
        "sessions": [
            {"device": "mobile", "country": "CA"},
            {"device": "desktop", "country": "CA"}
        ]
    }]
}

basically it is finding the user by the id, and then finding the connection by date, and then removing the device if mobile. In my particular case, the result is always one matching document and one matching connection and one matching session.

Parth Acharya · Accepted Answer · 2018-02-06 11:37:53Z

7

Because your sessions array is inside connections

Try "connections.$.sessions" instead of sessions so your query would be

Users.findOneAndUpdate({ "userId": "myId", "connections.dateConnectedUnix": 1334567891 },
    { $pull: { "connections.$.sessions" : { device: "mobile" } } }, (err) => {
        if (err) {
            return res.status(404).json({ message: 'Error' });
        }
        return res.status(200).json({
            success: true,
            message: 'success'
        });
    }
);

answered Feb 6, 2018 at 11:37

Parth Acharya

5453 silver badges13 bronze badges

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

Comments

James · Accepted Answer · 2023-05-02 05:02:24Z

0

Users.findOneAndUpdate(
    { "userId": "myId",  connections: { "$elemMatch": {dateConnectedUnix: 1334567891} } },
    { $pull: { "connections.$.sessions" : { device: "mobile" } } });

$elemMatch is required

ref: https://www.mongodb.com/docs/manual/reference/operator/update/positional/#update-embedded-documents-using-multiple-field-matches

edited May 2, 2023 at 5:02

answered May 2, 2023 at 4:59

James

11 bronze badge

1 Comment

moken Over a year ago

Answer needs supporting information Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

4b0 · Accepted Answer · 2021-08-11 13:52:02Z

-2

Users.findOneAndUpdate({ _id: "myId" }, { $pull: { connections.sessions: { device: "mobile" } } }, { new: true });

edited Aug 11, 2021 at 13:52

4b0

22.4k30 gold badges97 silver badges143 bronze badges

answered Aug 11, 2021 at 13:27

BILAL ARIF

212 bronze badges

Collectives™ on Stack Overflow

mongoose remove an object from a nested array

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related