In this example, it will be shown how to organize the filter application with blocks.
Creating a new query
1 – Create a new query application using the products table.
2- Select the ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice and UnitsInStock fields. To select the fields click on Select Fields located in the application menu.
Starting the query by the filter
3 – Access the Grid folder and click on the Grid Modules item.
4 – Check the Start by Search option.
Configuring blocks in the filter
5 – Access the Layout folder and click on the Blocks item.
6 –Click the Create New Block button.
7 – On the next screen, enter the name and label of the block.
8 – Configure the two blocks as shown in the figure below.
Associating fields with blocks
9 – Access the Select Fields item of the filter.
10 – Place the ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice and TotalValue fields in the Default Block.
11 – In the New Block block, place the UnitsInStock, UnitsOnOrder, ReorderLevel and Discontinued fields.