Add the value to the array in MongoDb only if it does not already exist in

Question

Add the value to the array in MongoDb only if it does not already exist in

Looking to make updates to a nested array within a document only if the item is not already included in the array:

await userCollection.findOneAndUpdate(
    { _id: ObjectId('616acc597ebda90ca6ffee21') },
    {
      'devices': {
        $push: {
          $cond: {
            if: {
              $in: [req.body.serial, '$devices']
            },
            then: '$devices',
            else: { serial: req.body.serial, data: [] }
          }
        }
      }
    },
    { returnOriginal: false },
    (err, _) => {
      if (err) {
        return res.status(400);
      } else {
        return res.status(200).json(user.value);
      }
    }
  );

This represents my user object structure:

{
    "_id": "616acc597ebda90ca6ffee21",
    "username": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="f783928483b783928483d994989a">[email protected]</a>",
    "displayName": "Test",
    "devices": [
      {
        "serial": "865674036421275",
        "data": [
          {
            "timestamp": "2021-10-16T12:36:35.799Z"
          },
          {            
            "timestamp": "2021-10-16T12:41:33.633Z"
          },
          {           
            "timestamp": "2021-10-16T12:52:03.055Z"
          }
        ]
      },
      
    ],
    "hashedPassword": "R5vt3vY7vEvTHvhC7YGNOWuIjBUQGLqsd92QGE06tjU=",
    "salt": "6RS0OVIFboCkIEPHdZmTcQ==",
    "dateCreated": "2021-10-16T12:58:00.294Z"
  }

Is there a method to verify if the serial already exists within devices? And can an error be triggered if it does?

javascript mongodb

Answer 1

Answer №1

Task

Locate and modify documents that do not contain a specific serial number
(using the eq/ne query operators to check if an array contains a certain value)
Replace the current serial with the desired serial number
Add the new entry at the end of the array
The updateOne method will provide the result, indicating whether the update was successful or not. Refer to your driver's documentation for more details.

*This process is efficient as it targets a specific document based on the matching _id, eliminating the need for an index on devices.serial

Try out the code snippet here

db.collection.update({
  "_id": ObjectId("616acc597ebda90ca6ffee21"),
  "devices.serial": {
    "$ne": "000"
  }
},
{
  "$push": {
    "devices": {
      "serial": "000",
      "data": []
    }
  }
})

It's important to note that update operators cannot be combined with aggregate operators. The $cond operator, which is used in aggregation, cannot be mixed with the $push update operator. (The aggregate $push is designed for grouping operations and cannot add elements to an array)

While updates can be performed using update pipelines, a standard update operation suffices in this scenario.

Answer 2

Task

Locate and modify documents that do not contain a specific serial number
(using the eq/ne query operators to check if an array contains a certain value)
Replace the current serial with the desired serial number
Add the new entry at the end of the array
The updateOne method will provide the result, indicating whether the update was successful or not. Refer to your driver's documentation for more details.

*This process is efficient as it targets a specific document based on the matching _id, eliminating the need for an index on devices.serial

Try out the code snippet here

db.collection.update({
  "_id": ObjectId("616acc597ebda90ca6ffee21"),
  "devices.serial": {
    "$ne": "000"
  }
},
{
  "$push": {
    "devices": {
      "serial": "000",
      "data": []
    }
  }
})

It's important to note that update operators cannot be combined with aggregate operators. The $cond operator, which is used in aggregation, cannot be mixed with the $push update operator. (The aggregate $push is designed for grouping operations and cannot add elements to an array)

While updates can be performed using update pipelines, a standard update operation suffices in this scenario.

Answer 3

Answer №2

To add elements to an array in MongoDB, you can use the addToSet operator. More information on how to use it can be found here

Answer 4

To add elements to an array in MongoDB, you can use the addToSet operator. More information on how to use it can be found here

Answer 5

Answer №3

Performing a MongoDB Raw Query

db.userCollection.updateOne({
    _id: ObjectId('616acc597ebda90ca6ffee21'), // Ensure that the ID is in Object Id format
    "devices.serial": {$ne: "SerialNeedToMatch" }
}, {
    $push: {
        "devices": {
            serial: '111' // Add new serial number or complete object 
        }
    }
})

Answer 6

Performing a MongoDB Raw Query

db.userCollection.updateOne({
    _id: ObjectId('616acc597ebda90ca6ffee21'), // Ensure that the ID is in Object Id format
    "devices.serial": {$ne: "SerialNeedToMatch" }
}, {
    $push: {
        "devices": {
            serial: '111' // Add new serial number or complete object 
        }
    }
})

Add the value to the array in MongoDb only if it does not already exist in

Answer №1

Answer №2

Answer №3

Similar questions

Vue.js Interval Functionality Malfunctioning

javascript with a focus on objects

Updating documents in a mongoDB collection can be done by simply

Populate Chart.js with a specific set of JSON data

Establishing a minimum date based on the date selected in the earlier datepicker

Load data onto a dropdown menu using Ajax requests

Pagination in DynamoDB: Moving forward and backward through your data

NextJS hot reload with Docker is a powerful combination for seamless development environments

The Angular 5 keyup event is being triggered twice

React is unable to identify the prop `controlID` when used on a DOM element in React-Bootstrap Forms

Unable to change the color of the RaisedButton component in Material-UI

Angular's observable function is not providing a complete response

How to retrieve the ID of a parent sibling using jQuery DataTables

Issue with V-checkbox input-value not triggering correctly on change

Avoiding Webpack externals when using library components / fragments

Prevent the default scroll event triggered by the mousewheel in certain situations. It is not possible to use preventDefault within a passive event

How can you access the input value from load dash's debounce function in a Vue.js application?

What is the best way to change a variable in an AngularJS view?

tips for efficiently using keyboard to navigate through tabs in an unordered list

When utilizing json.loads in Python 2.7, it yields a unicode object rather than a dictionary