MongoDb Atlas search , OR condition in Full text filter

Rohith_Nair · 2024-10-14T20:55:23.506Z

Hi , I have a collection like
{
“_id”: 1,
“Code” : “X1_XXX2”,
“Category”: “12”
},

{
“_id”: 1,
“Code” : “X1_XXX3”,
“Category”: null
}
I have Code and Category indexed in Atlas Search as default index
Question is how can I search say for example :
Code :“X1” where Category is “12” or null

So far I tried :

db.getCollection("myCollection").aggregate([
    {
        $search: {
            "compound":
                {
                    "filter": [{
                         '$or': [   // error  because i cannot use OR
                                  { Category: { '$eq': "000501" } },
                                  { Category: null },
                                 ]
                    }
                    ],
                    "must": [{
                        "wildcard": {
                            query: "SE*",
                            path: "Code",
                            allowAnalyzedField: true
                        }
                    }]
                }
        }
    },
    {
        $project: {
            "_id": 1,
            "Code": 1
        }
    }
])

Erik_Hatcher · 2024-10-15T09:43:37.184Z

You’re on the right track. The filter array supports Atlas Search operators directly. All filters are AND’d implicitly, though one of those filter clauses can be a compound.should to express the nested OR condition.