Node.js Mongodb toggling boolean operator doesnt work

Question

Hello Im having a weird issue

Ive looked in a few previous questions but ive ran into an issue

Basically I have a document containing a boolean

This boolean is called enabled

Id like to switch it using the findOneAndUpdate function

{ $set: { enabled: { $not: "$enabled" } } }

This is what ive come to according to previous questions

However when I attempt it this is the result

enabled: { '$not': '$enabled' }

Here is my full code

db.findOneAndUpdate({
    _id: "Sample"
}, {
    $set: {
        enabled: {
            $not: "$enabled"
        }
    }
}, {
    new: true
}, function(err, result) {})

You are trying to update the status of the enabled field to the opposite of the current value right? Like if the current state is false, then change to true and vice-versa? — chyke007
– chyke007, Commented Dec 31, 2022 at 0:39
Yes if its true it will become false if it is false it will become true — feefewfgwtg
– feefewfgwtg, Commented Dec 31, 2022 at 0:40

Joe · Accepted Answer · 2022-12-31 00:59:59Z

2

The problem is that you are trying to use the $not aggregation operator inside of a legacy update.

In order to use aggregation operators you will need to use Updates with Aggregation Pipeline.

For your example, this should be as simple as wrapping the update in an array like:

db.findOneAndUpdate({
    _id: "Sample"
},[{
    $set: {
        enabled: {
            $not: "$enabled"
        }
    }
}], {
    new: true
}, function(err, result) {})

answered Dec 31, 2022 at 0:59

Joe

29k4 gold badges25 silver badges50 bronze badges

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

2 Comments

Joe Over a year ago

If there is a document in the collection that doesn't have an enabled field, or has an enabled field with a non-boolean value, what should happen?

feefewfgwtg Over a year ago

That wont be the case thank you a lot for the help

chyke007 · Accepted Answer · 2022-12-31 01:06:25Z

1

You can use the $bit operator to toggle the value of the enabled field.

db.findOneAndUpdate({
    _id: "Sample"
}, {
   { $bit: { enabled: { xor: 1 } } }
}, {
    new: true
}, function(err, result) {})

On each update, the value enabled will toggle (1 to 0, 0 to 1).

Alternatively, you can use the set method as thus:

 db.findOneAndUpdate({
            _id: "Sample"
        }, [{
    $set: {
        enabled: {
            $not: "$enabled"
        }
    }
}], {
      new: true
        }, function(err, result) {})

edited Dec 31, 2022 at 1:06

answered Dec 31, 2022 at 0:47

chyke007

1,4731 gold badge10 silver badges16 bronze badges

3 Comments

feefewfgwtg Over a year ago

Is it possible to do this with a boolean ? I cannot tranisition the entire DB to use integers

chyke007 Over a year ago

I made an update to the answer

feefewfgwtg Over a year ago

I tried it but I got this weird result: enabled: { '$expr': [Object] }

Collectives™ on Stack Overflow

Node.js Mongodb toggling boolean operator doesnt work

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related