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.

Comment this post