Show TOC

Procedure documentationDefining Advanced Selection Variables Locate this document in the navigation structure

 

You can define variables (for advanced selection criteria), which users can use in mobile applications when they search for data.

Number of visits can, for example, be a criterion with the variables: minimum and maximum; users can enter values for these variables in the mobile application.

Prerequisites

  • You have defined the criteria for an advanced selection.

    For more information, see Defining Advanced Selection Criteria.

  • You have identified the names of tables and fields for the relevant business component of the advanced selection.

    Mobile System Maintenance (MSY) does not perform any validation on table and field names.

Procedure

Perform the following steps in MSY.

  1. Choose   Advanced Selection   Adv. Selection Variables  .

  2. Enter an ID, the prefix and suffix, and the SQL statement for the variable.

    The ID must begin with VAR, followed by numbers (VAR22, for example).

  3. Select the data type for the variable.

    If you choose Boolean Value, the Choice Field Key and Free Combo fields are defaulted to the Boolean choice field key. The available variable values are Set and Not Set.

    If you leave this field blank, the variable is assumed to be of the string data type.

  4. Empty Check indicates whether empty fields must appear in the result when a search is performed using this variable.

  5. If you want users to enter a value for the variable when they perform the search, select the Mandatory indicator.

  6. Replace Star by Percent indicates that if users perform wildcard searches in the mobile application by specifying the asterisk (*) sign for this variable, the asterisk must be replaced with a percentage (%) sign in the SQL statement.

  7. Save the changes.

    Note Note

    You can design the variable as a combo box.

    For more information, see Designing Advanced Selection Variables as Combo Boxes.

    End of the note.