Knowledge Drop

Are UI filters case sensitive by default?

  • 6 April 2021
  • 2 replies
  • 716 views

Userlevel 3
Badge

Last Tested: Jul 27, 2017

 

By default, case_sensitivity is on and filters are case sensitive. You can change this using the case_sensitive parameter at the model, explore, or field level. However, some dialects do not support this parameter. List of dialects here.

 

This content is subject to limited support.                

 


2 replies

Hi there! Is there an article I can follow to do this? Thanks!

Userlevel 3
Badge

Hi @jandv ,

The Looker documentation outlines how to use the parameter depending on the context in which you want it to apply. You can choose for it to apply model-wide, or restrict it to an explore or a field. You can see the docs for the model version here (and at the top it links to the docs for the other contexts).

Let me know if that helps!

Reply