1. App Builder User's Guide
  2. Managing Application Controls
  3. Managing Page Items
  4. Creating Page Items
  5. Creating a Shuttle Item on the Form Page

13.1.3.5 Creating a Shuttle Item on the Form Page

Create a shuttle item in Page Designer.

This section demonstrates how to create shuttle item type. In this example, you first create a report and form on the DEPT table. Then, you add a shuttle item to the form that lists employees alphabetically to make it easier to assign employees to a department.

To create a shuttle item on a form:

  1. Create a report and form on the DEPT table.
  2. View the form page in Page Designer:
    Page Designer appears.
  3. Create a new item from the Rendering tab or by adding it from the Gallery.

    The Property Editor displays the Page Item attributes. Attributes are organized in groups. To search for a group or an attribute, enter a keyword in the Filter Properties field. The Property Editor displays the group or attributes. Or, you can click Go to Group and select the group.

  4. Select the new page item in the Rendering tab and edit attributes in the Property Editor.

    To learn more about an attribute, select the attribute in the Property Editor and click the Help tab in the central pane.

  5. Under Identification:
    1. Identification, Name - Enter the name of this item (for example, PX_EMP_LIST).
      Where PX in the item name (for example P2_EMP_LIST) indicates the page on which the item resides.
    2. Identification, Type - Select Shuttle.
  6. Under List of Values:
    1. List of Values: Type - Select SQL Query.
    2. List of Values, SQL Query, enter:
      SELECT ename, empno FROM emp ORDER BY 1
  7. Under Source:
    1. Source, Type - Select SQL Query (return multiple values).
    2. Source, Item Source Value - Enter the SQL Query that returns one or more rows to be used as the source for this item value. If the result contains multiple rows then the value from each row is formed into a single colon delimited value. For example:
      SELECT empno FROM emp WHERE deptno = :P2_DEPTNO ORDER BY ename
  8. Under Multiple Values - Use these attribute to control how attribute lists are stored.
    1. Multiple Values, Type - Determines whether the Source Column contains multiple values, and how these are encoded.
    2. Multiple Values, Separator - Identifies the character which separates values from each other.

      Note:

      To learn more and view examples, see Page Designer Help or Configuring Multiple Value Attributes.
  9. To save your changes click Save.
  10. Run the application and view the revised form with the new Shuttle item.

Parent topic: Creating Page Items