Use array values as path to match documents

Working with Data
,
5

Hi @Ruben_FS,

If the structure of your documents is always :

  {
    _id: 1
    field: {
      subfield1: {
        subsubfield1: [  ...  ]
      },
      subfield2: {
        subsubfield2: [  ...  ]
      }
    },
    paths: [
      "field.subfield1.subsubfield1",
      "field.subfield2.subsubfield2"
    ]
  }

You can use this query :

https://mongoplayground.net/p/QOlMkJ4EPpj

1 Like