MongoDB find join array

Question

I have a collection with data that looks sort of like this

{
  "part": [
    { "a": "1", "b": "a" },
    { "a": "23", "b": "b" },
    { "a": "4", "b": "c" },
  ]
}

What I would like is a way of searching for documents where the join of all a parts equals the search that I am looking for.

for example 1234 should match the document above, but 124 should not.

is this possible with MongoDB?

NeNaD · Accepted Answer · 2021-12-19 11:23:45Z

2

You can do it with Aggregation framework:

$match with $eq - To filter only documents where concatenated a properties of part array are equal to the input string.
$reduce with $concat - To concatenate all a properties of part array for each document.

db.collection.aggregate([
  {
    "$match": {
      "$expr": {
        "$eq": [
          "1234",
          {
            "$reduce": {
              "input": "$part",
              "initialValue": "",
              "in": {
                "$concat": [
                  "$$value",
                  "$$this.a"
                ]
              }
            }
          }
        ]
      }
    }
  }
])

Working example

answered Dec 19, 2021 at 11:23

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

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

Comments

Viettel Solutions · Accepted Answer · 2021-12-19 11:11:16Z

1

You can use aggregate with $reduce to join string then $match to filter your string.
Here is the playground.

answered Dec 19, 2021 at 11:11

Viettel Solutions

1,52715 silver badges23 bronze badges

Collectives™ on Stack Overflow

MongoDB find join array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related