mongodb - How match nested fields in mongo by using the match clause?

Question

I am trying to match nested fields in a document in mongo but my query is not working.

Configuration:

[
  {
    linenumber: "car",
    type: "004",
    nested: {
      info: {
        subinfo: "B"
      }
    },
    
  },
  {
    linenumber: "car",
    type: "005",
    nested: {
      info: {
        subinfo: "G"
      }
    },
    
  }
]

query:

db.collection.aggregate([
  {
    $match: {
      $and: [
        {
          linenumber: "car"
        },
        {
          nested: {
            info: {
              subinfo: {
                $in: [
                  "B",
                  "G"
                ]
              }
            }
          }
        }
      ]
    }
  },
  {
    $group: {
      _id: null,
      types: {
        $addToSet: "$type"
      }
    }
  }
])

I am using the mongoplayground to test. Here is the link: https://mongoplayground.net/p/nND59iO1339

I am getting no documents found.

Answer 1

You are almost there. You need to use dot notation.

play

db.collection.aggregate([
  {
    $match: {
      $and: [
        {
          linenumber: "car"
        },
        {
          "nested.info.subinfo": { //Dot notation
            $in: [
              "B",
              "G"
            ]
          }
        }
      ]
    }
  },
  {
    $group: {
      _id: null,
      types: {
        $addToSet: "$type"
      }
    }
  }
])