i want to filter records by default, i.e. when opening a layout, just rows with "d_deleted=0" should be displayed. I want to use TO whichs filters, so the scripts should also work with not deleted rows by default.
The first thing I tried is a self-joined table with a calculation "k_0" which is fix "0" and a join with "d_deleted" on the left side and "k_0" on the right side and configuring the layout using the right sided TO. But when opening a layout, it starts sorting ... and never ends (at approx. 300 records).