AnsweredAssumed Answered

Filter records by default

Question asked by mjp on Oct 6, 2016
Latest reply on Oct 6, 2016 by David Moyer

Hi there,

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).


Any hint?