I saw this similar question:

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:
Screenshot from 2021-12-10 23-39-50

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

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.