Set Filter Criteria
Information
- By setting the filter criteria in module customizing, the customizer can define which data is displayed to the user in the module in question when it is opened. If the user wants to further restrict the displayed data, he/she can do so by setting additional temporary filter criteria. However, they do not remain in the module permanently but only apply to one filtering process. For information on application, see Filter and Filter Criteria
- The customizer can set so-called "blind" filter criteria for modules; they are invisible to the user, but they are essential for the logic of the application.
Procedure
- Fill the Filter from and Filter to parameters for the required data fields in the required data area.
- If you do not want the filter criteria set by the customizer to take effect, e.g. temporarily, you do not have to delete them but you can simply deactivate them via the Filter deactivated parameter.
- In modules with structured data you can use the Use filter on parameter to define the level at which the filter criteria is to take effect.
- In the Regular expression field, regular expressions can be specified as filter criteria. While normal filter criteria take effect on the database, regular expressions - just like filter criteria on virtual data fields - are analyzed in the main memory. Regular expressions can only be used for alpha numeric fields. If they are entered for fields of other types, a respective message is displayed.
- Via the Filter criteria parameter you can define on which data fields filtering is allowed. Only these fields will then be available in the Filter Criteria module.
- The parameters on which filtering is generally not possible are not displayed in the Filter Criteria module, regardless of the customizer’s setting. This concerns all data items with DF behavior "a", "ba", "c", "d", "m", "hk", "py".
- In virtual data items, the Filter from and Filter to fields and their values are marked in red in order for them to stand out against the real data items.
- The customizer can deactivate the Extras → Filter Criteria menu item if the user is to be unable to change filter criteria in the module.
Change Filter Criteria
Information
- Only users with customizer rights can change filter criteria permanently:
- in the customizing in the Data Areas module by adjusting the Filter from and Filter to parameters according to specific requirements as described above.
- directly in the application in the Filter Criteria module. However, the changed filter criteria cannot be saved directly in the Filter Criteria module. To do so, you have to switch to the reference module subsequently and save via the Tools → Module Customizing menu items.
- in the Option Module for MV.
Define Limits for Database Queries via Global Variables
Information
- By making specifications in the @G80109 and @G80110 global variables, the filter results of database queries (Filter) can be restricted.
- If the amount is greater than the amount specified in @G80109, the user will be asked whether the query is to be canceled.
- If the amount of found records is greater than the amount specified in @G80110, the query is always canceled (with a message).
- Default values are 50000 for @G80109 and 100000 @G80110 - these values can temporarily be changed by the Python code within a session.
- These values must be adapted to the requirements of the respective application. Further information on the interface can be found here.
- If these variables are set to 0 or a value smaller than 0, the respective functionality will be deactivated. This means that database queries with result sets of any size are admissible.