Filters Property

Version: Available or changed with runtime version 3.0.

Sets a set of filters for the page that will be applied for this page view. The following syntax is valid for the Filters property:

Filters = [WHERE(<TableFilters>)]
<TableFilters> ::= [<TableFilter> {,<TableFilter>}]
<TableFilter> ::= <RunObjectFieldName>=CONST(<FieldConst>) | FILTER(<FilterExpression>)

Applies to

  • Page View

Example

pagecustomization MyCustomization customizes "Customer List"
{
    views
    {
        addfirst
        {
            view(BalanceLCY)
            {
                Caption = 'Ordered Balance LCY';
                OrderBy = ascending ("Balance (LCY)");
                Filters = where ("Balance (LCY)" = filter (> 500), Name = filter ('G*'));
            }
        }
    }
}

For more information on how you can scan, find, and limit records in a list, see Sorting, Searching, and Filtering Lists.

See Also

Properties