like operator

[Fabi_Reyes]

Hi guys does anyone knows how i can create a condition on my model to restrict a specific text
i will like to have something like:

 join: cs {
    relationship: one_to_one
    sql_on: ${cs_db_.id} = ${cs_.id}
 when ${cs_db_clarabridge_inbox_mentions.Message Content} not like  {% '%I have been 7%' %} 
    ;;
  }

[elagos-16364795]

You can use any kind of SQL code in sql_on parameter. I have multiples CASE WHEN, IF, etc, it is not retricted to only LookML code. If that is not the problem, please give us more detail about it