Extend view with conditions

Hi All

I would like to know if I can create an extended view, with conditions in the extend on what it should put in that extend.
For example (this is not correct code, just how I imagine it):

view original_view {
    label: "Original View"
    sql_table_name: applications ;;
 }

   view finance_view {
  extends: [original_view]
  label: "Finance View"
  sql_where: application_status not in ('Cancelled', 'Declined') ;;
 }

regards,
GD

0 1 211
1 REPLY 1

sql_where is an explore option, not a view option. So, no, your LookML will not work.

This is what I recommend:

view original_view {
    label: "Original View"
    sql_table_name: applications ;;
 }
   view: finance_view {
  extends: [original_view]
  label: "Finance View"
 }
explore: finance_view {
sql_where: application_status not in ('Cancelled', 'Declined') ;;
}
Top Labels in this Space
Top Solution Authors