Filtering data within a grid

To filter certain information within a Grid, the WHERE clause can be used. - An application of the Grid type must be created 

 

2. Then within the query that is going to be done, the filter is placed in a field and a global variable will be used to receive the information and filter it according to the client's id.

 

3. Finally you must run the application and place an existing id to filter it into the Grid

 

5. And you can see that it filters by client

• Related Articles

• Email Export in Grid

  In the Query applications, you can configure the email export. This feature is used to export the Grid and send the export directly by e-mail to the configured recipients. E-mail export settings can be visualized in the Email export menu. Next, you ...

• Filtering Connection Database - Oracle

  On various occasions, we encounter slowness when connecting to the database or while editing and executing applications. It is possible to resolve these issues by optimizing data loading through filter configuration. To do so, follow these steps: ...

• Data dictionary

  The data dictionary is an important tool for the creation of multilingual systems, using this resource it is possible to create a data repository for use in the applications generated in the project or in new applications. The data dictionary is ...

• Hide certain fields in a Grid by means of various conditions

  When you need to hide fields through various conditions within the Grid, we can do it through a query. The first thing we are going to do is a query and we will store it inside a variable. Then we use the macro sc_lookup. After using said macro, we ...

• Limit number of records to be displayed in the Grid

  To limit the number of records to be displayed, we will use the Limit function within the query where they bring the data of a certain table. For example in this way: Then only 5 records are shown: