Edit interactive grid Attributes in Page Designer.

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, select the region containing the interactive grid.
3. In the Property Editor, select the Attributes tab.

   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.

Make an existing interactive grid editable by configuring attributes in the Edit group.

To make an interactive grid editable:

1. View the page in Page Designer:
   Page Designer appears.
2. In the Rendering tab, select the region containing the interactive grid.
3. In the Property Editor, select the Attributes tab.
   The Property Editor displays the attributes. Attributes are organized in groups
4. In the Property Editor Attributes tab, find the Edit group and update the following attributes:
   1. Enabled - Select On.
      Selecting On automatically creates a process to process the records.
   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.

      Lost Update Type options include:

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

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

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.

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.

Configure what controls display on the interactive grid toolbar.

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 and edit the following:
   1. Show - Select Yes or No to determine if a toolbar displays above the report.
   2. Controls - Configure the following:
      • Search Column Selection - Displays a drop down list of displayed non-numeric columns. If a column is selected, then the search is only performed against the values in the selected column.
      • Search Field - Displays a text field in the search bar used to enter search criteria.
      • Actions Menu - Displays the Actions menu button, which generally includes a comprehensive set of options. These options enables the end user to customize the report based upon the functions you make available.
      • Reset Button - Displays the Reset button. When clicked, any customizations, such as filters, column width, and ordering, are removed, and the report definition is reloaded from the server.
      • Save Button - Saves changes made to the interactive grid, without needing to save the whole page. The Save Button only displays when an interactive grid is editable and the end user has authorization to add, update or delete.
   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.

Enable users to save an interactive grid as a Public report.

To enable end users to save Public reports:

1. View the page in Page Designer:
   Page Designer appears.
2. In the Rendering tab, select the region containing the interactive grid.
3. In the Property Editor, select the Attributes tab.
   The Property Editor displays the attributes. Attributes are organized in groups
4. In the Property Editor, find the Enable Users To group and edit the following:
   1. Save Public Report - Select On. Selecting Off enables users to save the current report as a Public report.
   2. Save Public Report Authorization - Only displays if Save Public Report is set to On. 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.

Enable users to utilize flashback queries and define a chart in an interactive grid.

To enable Flashback or Define Chart View:

1. View the page in Page Designer:
   Page Designer appears.
2. In the Rendering tab, select the region containing the interactive grid.
3. In the Property Editor, select the Attributes tab.
   The Property Editor displays the attributes. Attributes are organized in groups
4. In the Property Editor, find the Enable Users To group and edit the following:
   1. Flashback - Specify whether end users can utilize flashback queries for this interactive grid.

      Flashback queries utilize the Oracle Flashback Technology and Database Point-in-Time Recovery to view data as it existed at a previous point in time. Users can only query this data, but can not rewind any data changes. How far back in time they can successfully perform a flashback query is determined by when the redo log files were last switched within the Oracle database, as this technology utilizes the RMAN backup.

   2. Define Chart View - Specify whether end users can define a chart for this interactive grid.
5. To save your changes click Save. To save and run the page, click Save and Run Page.