Knowledge Drop

How do I apply a filter for a whole view, regardless of what explore it's used in?

  • 5 April 2021
  • 0 replies
  • 14 views

Userlevel 5
Badge
  • New Member
  • 168 replies

Last tested: March 2021

 

 

You might want the behavior of sql_always_where to apply the view level rather than the explore level.

In that case, you can:

  1. Build a derived table with the desired WHERE clause,

  2. or use a sql_table_name like:

sql_table_name: (SELECT * FROM table WHERE X != 0) ;;

It is a feature request to be able to do this natively/with a parameter.

 

This content is subject to limited support.                


0 replies

Be the first to reply!

Reply