In C/AL code, you can use the FILTERPAGEBUILDER data type to create a filter page that enables users to set filters on multiple tables. Filter pages contains one or more filter controls, where each filter control can be used to set filters on a specific table. In the Microsoft Dynamics NAV client, filter pages are generated at runtime and run in a modal dialog box. The following figure illustrates a filter page that filters on the Item table.
To create a filter page, you use C/AL code and the functions that are available for the FILTERPAGEBUILDER data type. The following code example shows the C/AL code that creates the filter page in the figure.
 Copy Code | |
|---|---|
FilterPageBuilder.AddRecord('Item Table', Item);
FilterPagebuilder.Addfield('Item Table', Item."No.", '>100');
FilterPageBuilder.PageCaption := 'Item Filter Page';
FilterPagebuilder.RunModal;
Item.SetView( filterPagebuilder.Getview('Item Table')); | |
FILTERPAGEBUILER Data Type Functions
The following table describes the C/AL functions of the FILTERPAGEBUILER data type.
| Function | Description |
|---|---|
Adds a filter control for a table to a filter page. | |
Adds a filter control for a table to a filter page as specified by a record data type variable. | |
Adds filter control for a table to a filter page as specified by a recordref variable. | |
Adds a table field to the filter control for a table on filter page. | |
Adds a table field to the filter control for a table as specified by the field number. | |
Gets the filter view (which defines the sort order, key, and filters) for the record in the specified filter control of a filter page. | |
Sets the current filter view, which defines the sort order, key, and filters, for a record in a filter control on a filter page. | |
Builds and runs the filter page. | |
Gets the number of filter controls that are specified in the FilterPageBuilder object instance. | |
Gets the name of a table filter control that is included on a filter page based on an index number that is assigned to the filter control. |