Show TOC

Procedure documentationCreate an Entry List Locate this document in the navigation structure

 

The Entry List tab in the Control Property dialog box enables you to create a list of entries for the following types of controls:

  • Bulleted list

  • Combo box

  • Drop-down list

  • List box

  • Numbered list

  • Radio group

You can create the list by entering a set group of options - a "static" list - or you can create a list that dynamically takes its values from fields you designate (a "dynamic" list) and, optionally, according to a formula that you enter. The static and dynamic lists that you create here are used only for the defined control.

The   Tools   Entry List Manager   option enables you to create dynamic and static lists that can be used throughout the model; these are called "global" entry lists. This section describes how to create the different types of lists.

Procedure

To create a local, static entry list – for the specific control selected – do the following:

  1. After defining the controls for the form, go onto the Layout board, right-click the list control and choose Properties from the context menu. The Control Properties dialog box is displayed.

  2. Click the Entry List tab. From the List scope set of radio buttons, chose Static.

  3. Click the Add (Add) button at the right, and in the row created in the table, enter a Value (which is returned from the data service for the field) and the Display Text (which is the option that the user sees in the list).

    Example Example

    You might create a list as follows:

    Value

    Display Text

    US

    United States

    DE

    Germany

    GB

    Great Britain

    NL

    The Netherlands

    In this case, the list would contain four options, displayed according to the value received from the data service and shown according to the display text listed.

    End of the example.

  4. Click Close.

    Note Note

    When creating a combo box control, if a user enters text, that text will be taken as the value.

    End of the note.

To create a local, dynamic entry list – for the specific control selected – do the following:

  1. In the Entry List tab in the Control Properties dialog box (see step 1 in the previous procedure), choose Dynamic from the Entry list set of radio buttons. The Find Data Service dialog box is displayed.

    Note Note

    To create a dynamic entry list based on a JDBC-based stored procedure, see Create a Dynamic Entry List with a JDBC-Based Stored Procedure following.

    End of the note.

  2. Locate the data service you require:

    1. In the System drop-down list, choose the portal system in which the data service resides. If no list is available, click the Find Data button in the task-panel toolbar and choose the System there.

    2. From the Look for drop-down list, choose the data service that you require or enter a search string instead.

    3. Click Search and select your data service from the Select data service list.

  3. Using the Input port and Output port drop-down lists, choose the ports of the data service through which the data should be channeled and click OK. The fields channeled into the input port you defined are then displayed in the top table (Input port) of the Control Properties dialog box, in the Input Field column.

    Note Note

    If you are accessing a BI data service, be aware that the port names may differ from the port names of the same data service displayed in Storyboard.

    End of the note.

  4. In the Assigned Value column of the Input port table, define the input values that you require in order to get the output values you want in your list. You can:

    • Enter a fixed value, such as United States for an input field BANK_COUNTRY.

    • Use the Expression Editor (choose Enter formula) from the drop-down list to create a formula defining different values according to input value, such as: IF('US','United States','Other')

    • Enter a different field (using the Expression Editor) found in the form, from which to take the value. For example, for BANK_CTRY, you might assign a field @BANK_REGION.

  5. In the Output port table at the bottom, define the source field from which the VALUE should be taken and the corresponding field from which the display TEXT should be taken. For example, the VALUE might be BANK_KEY and the TEXT might be BANK_NAME.

  6. You can use the checkboxes below the output table to define the following options:

    • Sort: sorts the list options alphabetically

    • Allow duplicates: enters identical text options more than once, according to the results returned from the data service

    • Additional entries: enables you to add static text options to the list

      See the "Example" section following for a detailed example of a dynamic list.

To create a global entry list – for use in any list of the iView – do the following:

  1. Choose   Tools   Entry List Manager.  The Entry List Manager dialog box is displayed.

  2. At the bottom left, click Add and from the drop-down list, choose the type of entry list you want to create.

  3. Select the label text and rename the list appropriately.

  4. If you are creating a static entry list, follow the steps outlined in the first procedure ("To create a local static entry list") of this section. If you are creating a dynamic entry list, follow the steps outlined in the previous procedure ("To create a local dynamic entry list").

To apply a global list to a selected list control in a form, choose Global from the Entry list set of radio buttons in the Entry List tab of the Control Properties dialog box.

Result

The result of creating an entry list is similar to the following:

Runtime Entry List (Runtime Entry List)

Example

You would like to define a dynamic entry list to create a drop-down list of customer names: companies who do business with your company. You are going to use a data service called: BAPI_Customer_Details (which does not really exist). The input port receives the following required fields:

  • Sales_Mgr_ID

  • Max_Rows

For output to the list, the entry values should be received from the Customer_Number field, but displayed according to the Customer Name field.

You want the drop-down list of customers to be alphabetized, and have only one instance of each name. Therefore, you might fill in the dialog box as follows:

Entry List Tab (Entry List Tab)

The result would be a list of customers, similar to the following:

Final Runtime Result (Final Runtime Result)