9.5.3 Managing Interactive Grid Column Attributes

To edit interactive grid Column attributes:

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 the Rendering tab, locate the region and expand the Columns node.

   The columns appear in the Rendering tab.

3. Select a column to edit.
4. Edit the appropriate attributes.
   The Property Editor displays the attributes.

   Tip:

   To find a group or attribute, enter keywords in the Filter Properties field. The Property Editor displays the group or attributes. Or, click Go to Group and select the group.

5. To edit the column heading:
   1. Find Heading.
   2. Heading - Enter the report column heading text.
   3. Alignment - Select the heading alignment. Note that your alignment selection must be supported by the selected report template..
   4. Alternative Label - Enter the alternative label to use in dialogs and in the Single Row View. Use an alternative label when the heading contains extra formatting, such as HTML tags, which do not display properly.
6. To control how column values display and for editable grids how the column value is edited:
   1. Find Identification.
   2. Type - Select how the column is rendered.

      Different settings are available depending on the selected Type. For example, for an editable grid, select the Type Display Only to make a column uneditable. Choose the Type Hidden for primary key columns that should not be seen or other columns that are only used in templates such as icon or detail view, link targets, or columns of type HTML Expression.

      Note:

      To view help for an attribute, select the attribute in the Property Editor and click the Help tab in the central pane.

7. To control how users can manipulate a column:
   1. Find Enable Users To.
   2. Sort/Control Break/Aggregate - Select whether end users can use this column in sorts, control breaks, and aggregates. Select Yes or No.

   Tip:

   Enabling these operations can cause performance issues, especially on large data sets or where appropriate column indexes are not available.

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

   See Also:

   "Right Pane of Page Designer (Property Editor)"

To define a report column as a list of values:

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 the Rendering tab, locate the region and expand the Columns node.
3. Select the desired column.

   The Property Editor displays the attributes for the column. Attributes are organized in groups.

   Tip:

   To find a group or attribute, enter keywords in the Filter Properties field. The Property Editor displays the group or attributes. Or, click Go to Group and select the group.

4. In the Property Editor, find Column Filter. Specify the following:
   1. Enabled - Specify whether end users can filter this column. Select Yes or No.
   2. LOV Type - Select how to derive the list of values for the filter when a user clicks on the column header or in filter dialogs. See Page Designer Help for more details.

      Tip:

      To view help for an attribute, select the attribute in the Property Editor and click the Help tab in the central pane.

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

To create a column link to another page:

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 the Rendering tab, locate the region and expand the Columns node.
3. Select the desired column.

   The Column attributes appear in the Property Editor. Attributes are organized in groups.

   Tip:

   To find a group or attribute, enter keywords in the Filter Properties field. The Property Editor displays the group or attributes. Or, click Go to Group and select the group.

4. FindIdentification. From Type, select Link.
5. Find Link and click No Link Defined.

   The Link Builder - Target dialog appears. The Target Type you select determines the steps that follow.

6. To create a link to another page, in the Link Builder - Target dialog:
   1. Type - Select Page in this application.
   2. Page - Specify the target page number.
   3. Set Items - Select a Name and Value to specify session state for an item.
   4. Clear Session State, Clear Cache - Specify the page numbers on which to clear cache. To specify multiple pages, enter a comma-delimited list of page numbers.
   5. Rest Pagination - Select Yes to reset pagination for this page.
   6. Advanced, Request - Specify the request to be used.
   7. Click OK.
7. To create a link to another page in another application, in the Link Builder - Target dialog:
   1. Type - Select Page in a different application.
   2. Application - Specify the application.
   3. Page - Specify the target page number.
   4. Set Items - Select a Name and Value to specify session state for an item.
   5. Clear Session State, Clear Cache - Specify the page numbers on which to clear cache. To specify multiple pages, enter a comma-delimited list of page numbers.
   6. Rest Pagination - Select Yes to reset pagination for this page.
   7. Advanced, Request - Specify the request to be used.
   8. Click OK.
8. To create a link to a URL, in the Link Builder - Target dialog:
   1. Type - Select URL.
   2. URL - Enter the URL address.
   3. Click OK.
9. To save your changes click Save. To save and run the page, click Save and Run Page.