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 that shows which employees are assigned to a given department. Then, you create a shuttle item that lists employees alphabetically to make it easier to assign employees to a department.

To create a shuttle item on a form:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In Page Rendering, right-click region containing the form and select Create Page Item.
3. In the Property Editor, edit the following attributes:
   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.
4. In the Property Editor, edit the List of Values attributes:
   1. List of Values: Type - Select SQL Query.
   2. List of Values: SQL Query, enter:

      SELECT ename, empno FROM emp ORDER BY 1
      

5. In the Property Editor, edit the Source attributes
   1. Source: Type - Select SQL Query (return colon separated value).
   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 = :P8_DEPTNO ORDER BY ename
      

6. To save your changes click Save. To save and run the page, click Save and Run Page.