MongoDB does not support searching or editing with nested keys in the collection search bar

[MangoAm]

Description:

In MongoDB, nested key search is not supported in the collection search bar.
For example, given the original data: {a: {b: {c: 1}}}, I can only search using [a] = 'xxx' in the collection search bar, but I cannot use the syntax [a.b.c] = 1 to search.

When I use db.test.find({"a.b.c": 1}) in the shell or query editor, I am unable to edit the resulting data directly.

Expected behavior:

• Support searching with nested keys (e.g., [a.b.c] = 1) in the collection search bar.
• Allow editing of data found via nested key queries.

Actual behavior:

• Only top-level keys can be searched in the collection search bar.
• Data found via nested key queries cannot be edited.

Steps to reproduce:

1. Insert a document like {a: {b: {c: 1}}}.
2. Try to search for it using [a.b.c] = 1 in the collection search bar.
3. Try to edit the result after searching with db.test.find({"a.b.c": 1}).

[mikeburgh]

I have fixed the editable issue, the find method should now let you edit if you update to 1.19.5

Still working through the filter and nested cols

[MangoAm]

Great! This update is extremely useful!