2 Replies Latest reply on Oct 6, 2016 7:12 AM by David Moyer

    Filter records by default

    mjp

      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?

       

      Thanks,

      Markus