9.5.2 Managing Interactive Grid Attributes

To edit interactive grid 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 containing the interactive grid.
3. Under the region, select the Attributes node.

   The Property Editor displays the attributes. 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, you can click Go to Group and select the group.

4. Edit the appropriate attributes.

   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 make an interactive grid editable:

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 containing the interactive grid.
3. Under the region, select the Attributes node.

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

   Tip:

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

4. In the Property Editor, find Edit and update the following attributes:
   1. Edit - Select Yes.
      Selecting Yes automatically creates a process to process the records. When Enabled is set to Yes, additional options appear.
   2. Allowed Operations - Select supported data manipulation operations. Options include: Add Row, Update Row, Delete Row
   3. Allowed Row Operations Column - Select a column where the column value indicates if the row can be updated and/or deleted.
   4. Lost Update Type - Select how to protect data against lost updates.

      Lost updates occur when two or more users try to update the same data, and the last update overwrites updates made by the previous user. To prevent this, updates can check the existing column value(s) in the database with the value(s) retrieved when the record was originally queried. For an example, see Page Designer Help.

      • Row Values - A checksum value is calculated for each row, when initially querying the data. The checksum is calculated by concatenating all of the updateable columns into a string and then generating a unique value. When committing the updated record, this checksum is compared to the checksum value.

      • Row Version Column - If your database table includes a column which is incremented every time a record is updated, preferably by a database trigger, then this column can be used instead of calculating checksums. Oracle does not recommend this option if your interactive grid updates data in multiple tables.

   5. Add Row If Empty - Specify whether to add a new row if the interactive grid currently has no records returned. When enabled, the No Data Found message never displays since there will always be at least one record.  If no updates are made to the record that was added it will not be inserted when the region is saved.
5. To save your changes click Save. To save and run the page, click Save and Run Page.

To change interactive grid pagination:

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 containing the interactive grid.
3. Under the region, select the Attributes node.

   The Property Editor displays the attributes. 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. Find Pagination.

   Pagination attributes provide the end user with information about the number of rows displayed and the current position within the result set.

   Tip:

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

5. Under Pagination, edit the following attributes:
   1. Type - Select an option:

      • Page - Rows display based on what the end users select in the Actions menu, Format, Rows per Page option. If there are additional rows, controls are added to the report footer which enables users to navigate forwards and backwards between row sets.

      • Scroll - Rows display to fill the height of the interactive grid. As the end user scrolls, additional rows display as needed.

   2. Show Total Row Count - Select Yes or No.
      Selecting Yes displays the total row count in the report footer. Enabling this option requires an additional query which may hinder performance on very large data sets
6. To save your changes click Save. To save and run the page, click Save and Run Page.

To customize the interactive grid toolbar:

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 containing the interactive grid.
3. Under the region, select the Attributes node.

   The Property Editor displays the attributes. 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 the Toolbar group:
   1. For Show, select Yes or No to determine if a toolbar displays above the report.
   2. For Buttons, select which buttons display in the toolbar.

      Options include:

      • Reset - Reset removes any customizations (such as filters, column width, ordering, and so on) and reloads the report definition from the server.

      • Save - Save is only functional when an interactive grid is editable and the end user has authorization to add, update or delete. Save saves changes made to the interactive grid, without needing to save the whole page.

   3. Add Button Label only displays when the interactive grid is editable. For Add Button Label, enter an alternative label for the Add button. The default label is Add Row.
5. To save your changes click Save. To save and run the page, click Save and Run Page.

To enable end users to save Public reports:

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 containing the interactive grid.
3. Under the region, select the Attributes node.

   The Property Editor displays the attributes. 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, you can click Go to Group and select the group.

4. In the Property Editor:
   1. Find Enable Users To.
   2. Save Public Report - Select Yes
5. To save your changes click Save. To save and run the page, click Save and Run Page.

To restrict who can save a Public report:

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 containing the interactive grid.
3. Under the region, select the Attributes node.

   The Property Editor displays the attributes. 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:
   1. Find Enable Users To.
   2. Save Public Report - Select Yes
   3. Save Public Report Authorization - Select an authorization scheme.

      Select an authorization scheme to restrict who can save public report definitions. To enable an end user to save a public report, this authorization scheme must evaluate to TRUE for that user. If you do not select an authorization scheme, then any user may save public reports.

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