Multiple select with $in is not working no matter what I tried

[abedjaradat2017]

I saw this similar question:

Multiple Selection Dropdown

Hello Everyone Our company is using redash for one of our client and the database is MongoDB. I’m facing problem while implementing Multiple Selection Dropdown on a query. Query: { “collection”: “users”, “aggregate”: [ { “$match”: { “companyName”: { “$in”: [ “{{ userid }}” ] } } }, { “$project”: { “UserId”: “$userId”, “Name”: “$name”, “companyName”: “$companyName” } } ] } Result: blank screen

but unfortunately its not working for me

I have a list of drop down list, which reads from another query

I removed the double quotes around the parameter
{{gameId}}

and enabled Double quotes mark between for the values as in the image:

but I’m always getting the error:
Error running query: Invalid query format. The query is not a valid JSON.

Here’s the full query:

{
    "collection": "orders",
    "aggregate": [
        {
            "$match": {
                "status": {
                    "$in": [
                        "production",
                        "Shipped"
                    ]
                },
                "order_items.gameId": {
                    "$in": [
                        {{gameId}}
                    ]
                },
                "createdAt": {
                    "$gte": {
                        "$humanTime": "{{date.start}}"
                    },
                    "$lte": {
                        "$humanTime": "{{date.end}}"
                    }
                }
            }
        }
    ]
}

Please help me with this

Thank you so much

[jesse]

Using your browser’s network inspector, can you capture the query text that is sent to the back-end? It will be within a POST request.