Advanced Selection Details 
Use
This function allows you to enter details such as the name, SQL statement, table, and fields when a creating an advanced selection or while editing the details of an existing advanced selection.
Prerequisites
You know the names of the tables and fields of the relevant business components that you will use for the Advanced Selection.
There are no validations performed on tables and field names.
Features
· Advanced Selection General Details
You can specify the general details for an advanced selection such as a:
¡ Name for the advanced selection and a keyword that additionally identifies the advanced selection. The name that you enter here is displayed in a list in the Advanced Selection/ Adv. Selection List tile set. You can later access this advanced selection from this list.
¡ Logical selection operator, which is used to separate different criteria. The standard operator that is used is “AND”.
¡ Unique key that identifies the business object on which the advanced selection is based.
¡ Prefix to indicate the start of the [SEL] placeholder and a suffix to indicate the end of the [SEL] section in the SQL statement. Normally “ ( “ is entered as the prefix and “ ) “ as the suffix.
· SQL Defintion
The SQL statement that you build for an advanced selection must contain three placeholders [fields], [tables], and [sel].
When all the fields in two or more tables are used, then a join is specified. In case of a join, the parameter ‘deleted = 0‘ is mentioned in the SQL statement.
Select [fields] from [tables] where [sel] and table1.deleted=0 and table2.deleted=0 and table1.source= “ CAP “
· Table and Field Specifications
You specify the table name along with its alias. In most cases, the table alias is the same as the table alias entered in the SQL statement. Additionally, you also enter the names of the fields of the respective table and the names of the fields as they appear in the result set, while using the advanced selection in a mobile client application.
The Use As name is usually the same as the field name.
· Criteria Tree Structure Definition
You can enter only the main nodes of the tree structure. The criteria, which are displayed in the tree structure, are entered in the Adv. Selection Criteria tile set.
You also specify the language of the criteria in the tree structure. This allows you to construct a criteria tree structure in different languages. In addition, you also specify the sort key, which indicates the position of the criteria in the tree structure, in a numerical format. Entries with higher numbers appear first within the tree structure.
You may enter numbers in tens, e.g. 10, 20. This ensures numbering consistency when a new entry is made between existing nodes or between criteria.
See also: