Show TOC

Function documentationAdvanced Selection

 

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.

More Information

Advanced Selection Workflow