Advanced Selection 

Use

This function enables you to build a base SQL statement referred to as an Advanced Selection. It is used when you want to provide a mobile client user with the option of entering values while choosing the search criteria in a mobile client application.

You want the sales representative to view a list based on this SQL statement:

Business partner names and zones from the business partner details table where Zone = <user input>.

In this case, the zone could either be North, South, East, or West. Moreover, you want the sales representative to be able to indicate the zone. To represent this as an advanced selection, you build a base SQL statement as follows:

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

Where:

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

·         Tables: refer to the tables that contain the fields

·         Sel: refers to a selection based on the criteria indicated by the sales representative

In other words, the base SQL statement when used in the mobile client application will look like this:

Select [Business Partner Name, Zone] from [Business Partner Details Table] where [Zone = <user input>]

An Advanced Selection is:

·        Created for a specific business component using the Mobile System Maintenance application

·        Used by a mobile client user in a mobile client application

For more information, see Advanced Selection Object.

 

Integration

With the Mobile System Maintenance application components

To do this	Use this component
Generate a specific list of business partners at whom you want to target an activity journal template. For more information, see Target Group Generation: Advanced Selection Header.	Activity Journal Definition

With the Mobile Sales application components          

To do this	Use this component
Use specific criteria to search for a business partner	Business Partners
Use specific criteria to search for a contact person	Contact Persons
Generate a consolidated list of business partners and contact persons at whom you want to target a campaign. For more information, see Target Group Generation: Advanced Selection Header.	Marketing

With the Mobile Application Studio    

You use the Mobile Application Studio to integrate an Advanced Selection in a mobile client application. This integration includes modifying existing tiles for that specific business component. For more information, see Integrating Advanced Selection for a Business Component.

 

Features

·        Maintain Criteria

You can create, modify, and delete criteria or variables for an advanced selection.

·        Structure Criteria as a Tree Structure

A tree structure is a grouping of criteria in an advanced selection. You can view this tree structure in a mobile client application such as Mobile Sales.

 

The business partner component may have a tree structure as seen below:

·         Business Partner Criteria

·         Business Partner Details

·         Business Partner Name

·         Is a key account?

·         Contact Hours

·         Monday visiting hrs

·         Tuesday visiting hrs

·        Design a Combo Box

You can design a user input to appear as a combo box.

In the Advanced Selection below, you would like the sales representative to choose the zone from a list:

Select Business Partner Names and Zones from Business Partner Details Table where Zone = <user input>

In this case, you will design the variable Zone as a combo box.

 

See also:

Advanced Selection Workflow