Variable Definition 

Use

This function enables you to define variables for a criterion. These variables are later used by mobile client users to enter values when performing a search within a business component.

 

A criterion “Number of Visits” can have variables such as “Minimum Number” and  “Maximum Number”. A sales representative will enter values in these variables when using the search function.

 

Prerequisites

·        You have defined criteria for an advanced selection. For more information, see Criteria Definition.

·        You know the names of the tables and fields for the relevant business component of the advanced selection.

 

There are no validations performed on tables and field names.

 

Features

·        Variable Definition

Allows you to specify general details for a variable, such as the name, ID, prefix, suffix, and the SQL statement for the variable.

·        Data Definitions

Enables you to indicate the type of variable you want to define. You can choose the following data types for the variable:

¡        Date

¡        Boolean Value: On choosing this data type, the Choice Field Key field along with the Free Combo field gets defaulted to the boolean choice field key. The variable values available are “Set” and “Not Set”.

¡        String

¡        Numeric Value

 

If you leave this field blank then the string data type is assumed.

·        Indicator Options

¡        Empty Check: This is a flag allows empty fields to be displayed in the result set when a search function is performed using this variable.

 

A search on all customers with contact persons. The result set displays a list of all customers who have and do not have contact persons.

¡        Mandatory:  Indicates that a field is mandatory. If you choose this checkbox then, while using the advanced selection in a mobile client application the sales representative must enter a value for this variable before performing a search.

¡        Replace Star by Percent: This flag specifies that the percentage sign must replace the star sign. This will replace “ * “ with “ % “. If this checkbox is chosen then, while using the advanced selection in a mobile client application, if the mobile client user performs a “ * “ (wildcard) search on this variable the SQL statement will be replaced with a “ % “ and then executed.

·        Combo Box Design

Allows you to design a variable as a combo box. For more information, see Variable Design.