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