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.