Monday, 12 June 2017

Interactive Grid Features In Oracle APEX 5.1

Oracle APEX 5.1 comes with a new feature called Interactive Grid to display data in row/column matrix. In appearance, it looks similar to an Interactive Report (used in the next chapter) and delivers all features of an Interactive Report, but it also allows you to manipulate data simply by clicking on a cell and editing its value, which is not available in Interactive Reports.  In many ways this grid looks and acts like an Interactive Report. Here are some new features and differences:

  • Rows are fixed height and columns have a specific width that can be adjusted by dragging the border between column headers (G) or with Ctrl+Left/Right keys when the column header has keyboard focus.
  • Columns can be reordered with drag and drop (dragging the handle (E) at the start of a column heading) or with Shift+Left/Right keys when the column header has keyboard focus.
  • Columns can be sorted using the buttons (F) in the column heading or by using Alt+Up/Down key combination. Use the Shift key to add additional sort columns.
  • Columns can be frozen using the Freeze button  (D) in the column heading pop-up menu. For example, to freeze the customers’ name column (on Page 2), click the Name column heading. A pop-up menu will appear with four options: Hide (A), Control Break (B), Aggregate (C), and Freeze (D). Select Freeze. Drag the border between the Name and Address columns (F) toward right to expand the Name column.
  • By default the toolbar and column headings stick to the top of the page and the footer sticks to the bottom when scrolling.
  • By default pagination uses a "Load More" button.
  • The grid is keyboard navigable with a focused cell and current selected row (single selection by default).
  • The toolbar includes a Reset button by default, which restores all the report settings to their defaults.


To explore the features of the new Interactive Grid, you need a couple of tables that come with a sample application. Execute the following steps to install the sample application and consequently the required tables.


  1. Select Sample Apps from the Packaged Apps menu appearing at the top of your browser.
  2. Click the icon representing Sample Interactive Grids application.
  3. On the Packaged App Details page, click the Install Packaged App button.
  4. On the Install Packaged App wizard screen, accept the default Authentication scheme (Application Express Accounts) and click Next.
  5. On the next wizard screen, click the Install Packaged App button. After a while, you will see the message Application installed.
  6. Click the Object Browser option in the SQL Workshop main menu and see the two required tables (EBA_DEMO_IG_EMP and EBA_DEMO_IG_PEOPLE) in the left pane under the Tables category.




The instruction provided in this post are extracted from the book Oracle Application Express 5.1 Basics & Beyond









No comments:

Post a Comment