Table Filters

  • Table Row Filter feature allows the users to indicate conditions for filtering the rows of the table
  • This feature basically does the same as the WHERE clause in a SQL statement

In this article

Row Filter Condition

A view setting for an ability to horizontally partition a table with a where condition.

This is also one of the useful features that is in NF, where the developer can use it, wherever it is needed.

When the data that will be fetched from database, using an entity method need to be filtered per some conditions, then one or more row filters can be created for that entity table. During the execution of that method, these filters will be get used to filter the rows that is returned.

By using row filter, developer can avoid creating several entity methods and tables. Can create the method to return data without any conditions and just create the needed row filter with the conditions.

Field's Description

  • Table Name

    Represents the Entity table name under which the Table Fields are get added. Here it is internal (primary and foreign key) field.

    Need to provide the name of the entity table. It should be a unique name for that application.While creating new entity table, need to follow some naming procedures.

    Name should reflect for what entity / entity method it is going to be used for.

    If the table is going to be a Request table, then suffix the name with “Request”. Example as AccountTypeRequest.

    If the table is going to be used for Read purpose, then no need to any suffix. Example as AccountType.

    If the table is going to be used for Lookup control, then can name it like AccountTypeLookup.

    If the table is going to be used for CUD operation, then can name it like AccountTypeCUD.

  • Row Filter Name Need to provide a unique row filter name for this entity table. Give a proper name that identifies the use of this filter.

  • Is Default ? This identifies that this setting should be the default one for this entity table. There can be only one item, that can be set as default for that entity table.
    By default, this option is false.

  • View Filter Description A short description of this view filter usage.

  • TableCondition

    Need to provide the SQL condition that need to be used for this row filter.

    For example, for the “Account” Response Table, to filter the rows that are of “AccountTypeId” 2, then can give the condition as “account_type_id=2”

  • Request Table Name If the provided condition for the row filter need to use a request table, that can be selected from this dropdown list.

  • Row Identifier Internal field.

  • Created User User who created that Entity object.

  • Created Date Date in which Entity object was created.

  • Updated User User who updated that Entity object lastly.

  • Updated Date Date in which Entity object was last modified.