Filtering data within a grid

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 ...

    • 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 ...

    • 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:

    • 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 ...

    • Enabling Nested Grid export on XLS

      You can enable Nested Grid exports when you want to export in XLS format. This option is useful when you want to generate complete XLS reports. To enable Nested Grid export, go to the menu Nested Grid -> Settings.  Then, in the XLS option, you can ...