Query specific element of nested array or default

Question

Having document in collection test as follow:

{a:1, list:[{lang:"en", value:"Mother"}, {lang:"de", value:"Mutter"}] }
{a:2, list:[{lang:"en", value:"Iddqd"}] }

I would like build query that tries to match list.value to selected language, but if it absent then return any-available-item of list, so for example above and for query language de i need get $projection as:

{a:1, label:"Mutter"},
{a:2, label:"Iddqd"} //since no label matched 'de' let's select any available

Server version: MongoDB 3.2+

Can you please elaborate on why you should get {a:2, label:"Iddqd"} for the second document? — Sede
– Sede, Commented Sep 29, 2016 at 16:13
@Styvane - just updated, in short "Iddqd" - is any available item. List is rather short - not exceeding 10 — Dewfy
– Dewfy, Commented Sep 29, 2016 at 16:24

Sede · Accepted Answer · 2016-09-30 08:40:34Z

1

You need to filter the list, assign the result to a variable using the $let operator. If the variable is an empty list, you return a given value using the $arrayElemAt operator. In this case, I simply return the first sub-document.

db.coll.aggregate([
    { "$project": { 
        "a": 1, 
        "label": { 
            "$let": { 
                "vars": { 
                    "values": {
                        "$arrayElemAt": [ 
                            { "$filter": { 
                                "input": "$list", 
                                "as": "lst", 
                                "cond": { "$eq": [ "$$lst.lang", "de" ] }
                            }}, 
                            0 
                        ] 
                    } 
                }, 
                "in": { 
                    "$ifNull": [ 
                        "$$values.value", 
                        { "$let": { 
                            "vars": { 
                                "default": { 
                                    "$arrayElemAt": [ "$list", 0 ]
                                } 
                            }, 
                            "in": "$$default.value" 
                        }}
                    ]
                }
            }
        }
    }}
])

edited Sep 30, 2016 at 8:40

answered Sep 29, 2016 at 16:43

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

2 Comments

Dewfy Over a year ago

Not sure why, but $filter returns both items of array that contains de and en as well

Sede Over a year ago

@Dewfy I've update my answer. Will add more explanation when have a little time.

Collectives™ on Stack Overflow

Query specific element of nested array or default

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related