Hi,

I am calling a query on my ddx brick using domo query functions. Now when i try to pass filters which actually are the where clauses in which my where conditons are defined as comma separated. all are with IN operand.

but getting the following error:

"DA0012: A filter was provided to filter the data but it contains a grammatical error or is otherwise invalid and it could not be parsed. The offending filter is: company_id IN (207) . \nThe parsing error is: expression values cannot be parsed at company_id IN (207)"

And my where clause code is as below :

["company_id IN 207",
"facility_ids IN 3631,3632,3633,3634",
"participant_gender IN male"
]

And in the query I am making it as a join as describe in docs as below:

can any one please help me that what is the right format for passing where clauses? because for some columns i have integer values, and for some i have string values and both are comma separated.