Advanced query with mongodb with several conditions

Question

My mongodb document contains object CarData with several properties inside.

{
   _id: ...,
   Name: "",
   CarData: {
     carId: null,
     ownerName: "",
     ownerPhone: "",
     AdditionalInfo:{
       RefNr: ""
       validDoc: true
    }
   }
}

I know I can query the whole collection

{ "CarData": { $exists: true } }

but I don't know how to query whole collection with

CarData exists and is not null 
and ownerName != "" 
and AdditionalInfo exists and  != null 
and AdditionalInfo.validDoc == true

Rubén Vega · Accepted Answer · 2021-12-28 10:28:33Z

1

In mongo you don't need to check if the fields exist before checking internal properties. I think this should be enought for you. Playground

db.collection.find({
  "CarData.ownerName": {
    "$ne": ""
  },
  "CarData.AdditionalInfo.validDoc": true
})

answered Dec 28, 2021 at 10:28

Rubén Vega

7307 silver badges14 bronze badges

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

Comments

Dharman · Accepted Answer · 2021-12-28 10:46:42Z

To get the documents as per your specification. you have to use aggregation provided by MongoDB. The query below will fulfill your requirements.

db.collection.aggregate([
  {
    $match: {
      "$and": [
        {
          CarData: {
            "$exists": true
          }
        },
        {
          CarData: {
            "$ne": null
          }
        },
        {
          "CarData.ownerName": {
            $ne: ""
          }
        },
        {
          $and: [
            {
              "CarData.AdditionalInfo": {
                "$exists": true
              }
            },
            {
              "CarData.AdditionalInfo": {
                "$ne": null
              }
            },
            {
              "CarData.AdditionalInfo.validDoc": true
            }
          ]
        }
      ]
    }
  }
])

The above query will give the list of documents with the matching condition.

Collectives™ on Stack Overflow

Advanced query with mongodb with several conditions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related