Checking for string in Array

Looker Q&A Looker
,
1

Hi,

How best can I check if a string is IN an array.

Lets say this is the dimension (array):

dimension: tags {
    type: string
    sql: ${TABLE}.tags ;;
  }

This measure doesn’t work

measure: fund_count {
    type: sum
    sql:
      CASE WHEN ${TABLE}.tags LIKE '%"Fund Fee"%'
          THEN ${count}
      END ;;
  }

Thanks.

2

Found the answer:

I added JSON_SERIALIZE to the dimension array

dimension: tags {
​​​​​​​   type: string 
   sql: JSON_SERIALIZE(${TABLE}.tags) ;; 
}