How do I use multi-select fields as an multi-select Insights parameter?

Sewon
Sewon
  • Updated

Issue

I want to use a multi-select field as an multi-select Insights parameter but I am getting the following error message: operator does not exist: jsonb = text

 

Environment

Insights

 

Cause

You have to use a different format for multi-select fields.

 

Resolution steps

Modify your SQL dashboard to the following:

- If you want at least one key in the parameter to match your field:

Field ?| {{Parameter}} OR CARDINALITY({{Parameter}}) = 0

- If you want all keys in the parameter to match your field:

Field ?& {{Parameter}} OR CARDINALITY({{Parameter}}) = 0

 

Was this article helpful?

Have more questions? Submit a request