Show TOC

Function documentationAdvanced Selection Locate this document in the navigation structure

 

This function allows you to build base SQL statements, which give users the option of entering values while choosing search criteria in a mobile application.

Example Example

You want users to be able to view names of business partner names in a specific zone (North, South, East, or West).

To do this, you can build a base SQL statement as follows:

select [fields] from [tables] where [sel]

[fields] is the list of fields that users must be able to view

[tables] is the list of tables that contain the fields

[sel] is the set of selection criteria specified by users

End of the example.

For more information, see Advanced Selection Object.

Integration

  • You can use the SQL statements creating using this function to generate a list of business partners for whom you want to make an activity journal template applicable.

    For more information, see Target Group Generation: Advanced Selection Header.

  • You can integrate advanced selection in a mobile application using the Mobile Application Studio (MAS). This integration includes changing existing tiles for business components.

    For more information, see Integrating Advanced Selection for a Business Component.

  • Sales representatives can search for business partners based on specific criteria in the Business Partners component of Mobile Sales.

  • Sales representatives can search for contacts based on specific criteria in the Contact Persons component of Mobile Sales.

  • Sales representatives can generate a consolidated list of business partners and contacts at whom a campaign must be targeted, in the Marketing component of Mobile Sales.

    For more information, see Target Group Generation: Advanced Selection Header.

Features

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

  • You can view advanced selection criteria in the form of a tree structure in a mobile application.

    Example Example

    The business partner component may have the following tree structure:

    Business partner criteria

    Business partner details

    -- Name

    -- Is a key account?

    Contact hours

    -- Monday visiting hours

    -- Tuesday visiting hours

    End of the example.
  • You can design user input criteria to appear as combo boxes.

    If, for example, you want users to be able to search for business partners in a specific zone, you can design the variable, Zone, as a combo box.