Double nested array with multiple nested documents identify wrong value

Question

I need to identify which documents have the wrong date string ( $gt:10 characters) from all my collection :

  {
    "_id": ObjectId("5c05984246a0201286d4b57a"),
    f: "x",
    "_a": [
      {
        "_onlineStore": {}
      },
      {
        "_p": {
          "s": {
            "a": {
              "t": [
                {
                  "dateP": "20200-09-20",
                  "l": "English",
                  "size": "XXL"
                }
              ]
            },
            "c": {
              "t": [
                {
                  "dateP": "20300-09-20",
                  "l": "English",
                  "size": "XXL"
                }
              ]
            }
          }
        }
      }
    ]
  }

and output need to be as follow:

{f:"x",dateP:"20200-09-20", t:"c"}
{f:"x",dateP:"20300-09-20", t:"a"}

The last field in the output "t" not compulsory but desirable ... Please, help ...

Yong Shun · Accepted Answer · 2022-10-13 01:15:45Z

2

We can use $objectToArray for this:

db.collection.aggregate([
  {$unwind: "$_a"},
  {$project: {_id: 0, f: 1, data: {$objectToArray: "$_a._p.s"}}},
  {$unwind: "$data"},
  {$unwind: "$data.v.t"},
  {$match: {$expr: {$gt: [{$strLenCP: "$data.v.t.dateP"}, 10]}}},
  {$project: {f: 1, dateP: "$data.v.t.dateP", t: "$data.k"}}
])

See how it works on the playground example

edited Oct 13, 2022 at 1:15

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

answered Oct 12, 2022 at 14:28

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

1 Comment

R2D2 Over a year ago

I have related new challenge here: stackoverflow.com/questions/74055077/…

Collectives™ on Stack Overflow

Double nested array with multiple nested documents identify wrong value

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related