Mongodb aggregate

MongoDB Atlas Atlas Search
,
1

I am trying to search products by price range with MongoDB aggregate.But I didn’t solve this yet.Help me, anyone,please

2

Could you post a sample query and some sample documents? Number facets could help.

1 Like
3 
[
            {
                "$search": {
                    "compound": {
                        "should": [
                            {
                                "text": {
                                    "path": ["category", "price", "title", "shop"], "query": `\"${search}\"`,
                                    "score": {
                                        "constant": {
                                            "value": 1
                                        }
                                    }
                                }
                            }
                        ],
                        "must": [
                            {
                                "text": {
                                    "path": ["title", "category", "shop", "price"],
                                    "query": `\"${search}\"`,
                                }
                            }
                            ,{
                                "text": {
                                    "query": `{price:{$gte:${Number(lowestPrice)},$lte:${Number(highestPrice)}}}`,
                                    "path": 'price',
                                    "score": {
                                        "constant": {
                                            "value": 1
                                        }
                                    }
                                }
                            }
                        ],
                    }
                }
            },
            {$project: {
                "_id": 1,
                "title": -1,
                "category": 1,
                "price": { $cond: [{ $eq: ["$price", null] }, "$$REMOVE", "$price"] },
                "price": { $cond: [{ $eq: ["$price", 0] }, "$$REMOVE", "$price"] },
                "shop": 1,
                "createdAt": 1,
                "link": 1,
                "image": 1,
                "score": { "$meta": "searchScore" },
                "highlight": { "$meta": "searchHighlights" }
            }}
        ];
4

price filtering doesn’t working

5

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.