I need to retrieve the index(number 1) information in mongodb compass-CodePudding

I just need to query all information of the doctor in the first index.

Find doctor by name query

{ name: "Mavis Bxxxed" }

Find doctor by patient name

{ "patients.name": "Some one" }

If same search with this query

{ "patients.name": "Itch Txxx" }
OR
{ "patients.name": "Damon Wxxx" }

will same result to find the first docker (Mavis Bxxxed) Due to it's patients start [ and end ]. it is array type a single size of data.

You can filter by project option

  {
    patients: {
      $filter:
      {
          input: "$patients",
          cond: { $eq: [ "$$patient.name", "Itch Txxx"] },
          as: "patient"
      }
    }
  }

OR shows only address

{ "patients.address" : 1 }