mongodb / nodejs: findandmodify method not working - Web Client Dev

TopAnswers Web Client Dev

Meta

Databases

TeX

Code Golf

APL

C++

.net

db<>fiddle

Java

*nix

PHP

PowerShell

Python

Rust

टेक्-मराठी

Typst

Web Client Dev

Web Server Dev

mongodb / nodejs: findandmodify method not working

add tag

5 years ago Anonymous 1731

I have below json data and want to update the value according to the condition

{
    "_id" : ObjectId("5fce2d4c7b2ea2e79ercvju4"),
    "userId" : 1,
    "token": "jwt_token_value",
    "isActive" : 0,
    "__v" : 0
}
{
    "_id" : ObjectId("5fce2d4c7b2ea2e79ercvjk0"),
    "userId" : 1,
    "token": "jwt_token_value",
    "isActive" : 0,
    "__v" : 0
}
{
    "_id" : ObjectId("5fd0d45tjd82a02dd0f17fc4"),
    "userId" : 1,
    "token": "jwt_token_value",
    "isActive" : 1,
    "__v" : 0
}

xxxxxxxxxx
 
{    "_id" : ObjectId("5fce2d4c7b2ea2e79ercvju4"),    "userId" : 1,    "token": "jwt_token_value",    "isActive" : 0,    "__v" : 0}{    "_id" : ObjectId("5fce2d4c7b2ea2e79ercvjk0"),    "userId" : 1,    "token": "jwt_token_value",    "isActive" : 0,    "__v" : 0}{    "_id" : ObjectId("5fd0d45tjd82a02dd0f17fc4"),    "userId" : 1,    "token": "jwt_token_value",    "isActive" : 1,    "__v" : 0}
show all 21 lines

I have managed the things as below.

let update = await UserDetails.findAndModify(
    { userId: 1, token: token },
    [],
    {$set: { isActive: 0 }},
    { new: true }
);

xxxxxxxxxx
 
let update = await UserDetails.findAndModify(    { userId: 1, token: token },    [],    {$set: { isActive: 0 }},    { new: true });

=> This query should update the last json collection key of isActive to 1. But it is not updating the values any how. What the things that I am doing wrong ? It is not throwing me any error as well to debug.

0 Answers