Advanced Selection Object 

Definition

This is a base SQL statement containing parameters such as tables, fields, criteria, and variables. These parameters are combined with an “OR” or an “AND” in the SQL statement.

Advanced Selection Object is an equivalent name for Advanced Selection.

In the SQL statement:

Select [fields] from [tables] where [sel]

Where:

·         Fields: refer to the field names that you want displayed

·         Tables: refer to the table that contains the fields

·         Sel: comprises criterion1 AND criterion2

For a business partner search by zone, the SQL statement could be as follows:

SELECT [Business Partner First Name, Zone] FROM [Business Partner Details Table] WHERE [Language = “English” AND {Zone = “North” OR Zone = “East”}]

 

Structure

An Advanced Selection comprises the following parameters:

...

       1.      Criterion

A criterion is a collection of variables that could either be:

¡        Entry fields: The criterion corresponds directly to one or more fields from the table. The sales representative can perform a search based on the values entered in these fields.

The sales team member can be provided with the criterion “Business Partner Name” to perform a search on all business partners. “Business Partner Name” refers to a field from a table.

¡        Calculable fields: These fields can be fields that perform certain calculations based on data from more than one field from a table(s).

The sales representative wants to display the number of visits made to a business partner. The sales representative can use the criterion “Number of visits”, which will display a calculated value on the number of visits made to the selected business partner.

“Number of visits” is not a field that belongs to a table but a criterion provided to facilitate an easier search.

¡        Mixture of both entry fields and calculable fields.

       2.      Variable

A variable may be:

¡        A range: For example, a criterion “Date” can have a range such as “Start Date” and “End Date”.

¡        An entry field: For example, a criterion “Business Partner Name” can have variables such as “First Name” and “Last Name”. The sales representative will enter values in these variables to perform a search.

A variable further contains values.

       3.      Value

Values are entries specified for the variables, while using the Advanced Selection in a mobile client application.

<10/23/01> is a value for the variable “Start Date”. 

OR 

<Smith> is a value for the variable “Last Name” of the criterion “Business Partner Name”.

 

See also:

Advanced Selection