Finding field name in MongoDB nested data

Question

Is it possible to find the 'field name' using a regex first and then use that field name to find its value across all documents?

For example, if I have the following structure:

item : Object
  - quantity: 50
  - size: Object
    - h: 20

Ideally, if I want the value of h, I would query item.quantity.size.h ("field.nestedField"). However, I only know the name 'h' but not what it is nested under. Is it possible to retrieve the entire field name (item.quantity.size.h) and its value (20)? I would then like to use that field name to obtain the value from all other documents.

Please provide example data. Is a level an object or an array? — nimrod serok
– nimrod serok, Commented Apr 1, 2022 at 6:22
@Sassy your newly added sample data is still not clear about its structure. It would be the best if you can provide valid json documents. — ray
– ray, Commented Apr 2, 2022 at 15:13

nimrod serok · Accepted Answer · 2022-04-02 15:05:45Z

0

Inspired by: MongoDB javascript `"$function"` not returning expected value in mongoplayground.net

You can use a $function aggregation, like this:

    db.collection.aggregate([
  {
    $project: {
      data: "$$ROOT"
    }
  },
  {
    "$project": {
      "flattenKeys": {
        "$function": {
          "body": "function flatten(dataList, keysToHandle){while(keysToHandle.length){origKeyData = keysToHandle.shift();for (const newKey of Object.keys(origKeyData.objData)){keysToHandle.push({objData:origKeyData.objData[newKey],keyData:`${origKeyData.keyData}.${newKey}`});dataList.push(`${origKeyData.keyData}.${newKey}`);}}return dataList}",
          "args": [
            [],
            [
              {
                objData: "$data",
                keyData: "data"
              }
            ]
          ],
          "lang": "js"
        }
      }
    }
  },
  {
    $project: {
      matchingKeys: {
        $filter: {
          input: "$flattenKeys",
          as: "item",
          cond: {
            $regexMatch: {
              input: "$$item",
              regex: "keyD"
            }
          }
        }
      }
    }
  }
])

See how it works here

answered Apr 2, 2022 at 15:05

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

2 Comments

Sassy Over a year ago

Does not work in pymongo

Sassy Over a year ago

it gives an Out of memory OperationFailure even after adding allowDiskUse=True

Collectives™ on Stack Overflow

Finding field name in MongoDB nested data

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related