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. 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.

3. Edit the appropriate 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.

4. 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.
5. 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
      

6. Under Source:
   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
      

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