How to remove an object in array in mongoose query

Question

Please I am new in mongo db and I want to delete one item from my list, I tried several approches but it's not working.

{

name: 'ABCDE',

snapshotString: [
        '{"timestamp":1589316266621,"testObject":{}, "moreAttributes" : "XXXXX"}',
        '{"timestamp":1589316279337,"testObject":{}, "moreAttributes" : "XXXXX"}'
],
snapshots: [
   1589316266621,
    1589316279337
]
}

I want to delete a snapshotString for given timestamp I did this:

this.testCase.updateOne(
                {name:room, "snapshotString.timestamp": timestamp}, 
                { $pull: { "snapshotString.timestamp": timestamp } }, { safe: true }, 
                function(err, obj) {
                    console.log(" ***** err ***** "+err);
        });

And it's a way to have one query to delete both documents with timestamp in snapshotString and snapshots in the same query?

Thanks

Does this answer your question ? stackoverflow.com/questions/16959099/… — whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul, Commented May 12, 2020 at 21:56
In that example snapshotString contains an array of strings, not an array of objects. Strings don't have fields, so you can't query snapshotString.timestamp - it will never match anything. You might try a regular expression for that match. — Joe
– Joe, Commented May 12, 2020 at 22:05

ngShravil.py · Accepted Answer · 2020-05-13 03:27:32Z

1

You can try the below:

this.testCase.updateOne(
    {name: room},
    {$pull:
        {snapshotString:
            {$regex: timestamp}
        }
    });

Note: I am assuming here, timestamp is a string, if not, then you should convert it to string, as $regex operator will accept only string.

answered May 13, 2020 at 3:27

ngShravil.py

5,0983 gold badges21 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How to remove an object in array in mongoose query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related