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 making temporary settings of further filter criteria. However, they don’t remain permanently in the module but only apply to one filter 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

  • Open the required data area in the Data Areas module.
  • Fill the Filter from and Filter to parameters for the required data fields.
    • If you do not want the filter criteria set by the customizer to take effect, e.g. temporarily, they do not have to be deleted but they can simply be deactivated 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 you can specify regular expressions as filter criteria. While normal filter criteria affect 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.
  • 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 also deactivate the Extras → Filter Criteria menu item, if he/she does not want users to be able to change filter criteria in the module.

Change Filter Criteria

Information

  • Only users with customizer rights can change filter criteria permanently:
    1. in the customizing in the Data Areas module by adjusting the Filter from and Filter to parameters according to your requirements as described above.
    2. directly in the application in the Filter Criteria module. However, you cannot save the changed filter criteria directly in the Filter Criteria module. To do so, you have to switch to the reference module subsequently and save via the Tools → Save Module Customizing menu items.
    3. 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 you can restrict the filter results of database queries (Filter).
    • 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. I.e., database queries with result sets of any size are permitted.