Filter Setup

Filters allow users to narrow down data in the List by applying conditions to the data table. Filters are based on the fields of the object configured in the List Configurator. In the filter settings, users can add and configure filters with various conditions (e.g., Equals, Contains, Greater Than, Less Than) to display only the desired data. By combining multiple filters, users can create complex search conditions. This powerful filtering functionality helps users quickly and efficiently locate essential information within large datasets, significantly improving data analysis and decision-making processes.

Filters in List

🔸 Filtering Logic

Filter Priority When the List Configurator is first loaded on the page, filters are applied in the following order of priority:

1. ListView Filter

2. DATATABLE SETUP where

3. URL Parameter

4. Default Filter Value

5. Preserved Filter Value

Filter Logic Diagram

🔻 Detailed Filtering Logic

  • Role of the List View Filter

    • Users can create multiple list views from a single base list view.

    • The filters defined by the user in this context are called List View Filters, and they are applied with the same priority as the WHERE condition in the DATATABLE SETUP.

    • In other words, the List View Filter is the highest priority filter applied.

  • When URL Parameters Are Present

    • Upon loading the list, the WHERE condition from DATATABLE SETUP is applied first.

    • If filter values are provided via URL parameters, they are combined with the WHERE condition using an AND operator.

    • In this case, Default Filter Values and Preserved Filter Values (locally stored user inputs) are ignored.

  • When URL Parameters Are Not Present

    • Check whether filter value preservation is enabled.

      • If "Preserve Filter Values" is Enabled

        • The system retrieves the user's filter inputs stored locally.

        • It compares these with the Default Filter Values.

        • If any default filters are not present in the local storage, those values are added.

        • The combined filters are then applied together with the DATATABLE SETUP WHERE condition using AND.

      • If "Preserve Filter Values" is Disabled

        • The Default Filter Values are used as-is.

        • They are combined with the DATATABLE SETUP WHERE condition using AND.


🔸 Screen Configuration

Filter Setup
No.
Name
Description

1

Preserve Filter Values

When enabled, filter input values are retained even after a page refresh.

2

Filter Layout

Specify the number of filters to display per row.

  • 3 of 12: Displays 4 filters per row. (Default)

  • 4 of 12: Displays 3 filters per row.

3

Add filters based on the fields of the configured object and edit their attributes according to the filter type.

Last updated

Was this helpful?