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?
You can do it with Aggregation framework:
a properties of part array are equal to the input string.a properties of part array for each document.db.collection.aggregate([
{
"$match": {
"$expr": {
"$eq": [
"1234",
{
"$reduce": {
"input": "$part",
"initialValue": "",
"in": {
"$concat": [
"$$value",
"$$this.a"
]
}
}
}
]
}
}
}
])
You can use aggregate with $reduce to join string then $match to filter your string.
Here is the playground.