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
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') ;;
}