About this Application

Sample Interactive Grid explores the many uses and features of the Oracle Application Express Interactive Grid.

About the data used

Most of the examples in this application use a modified EMP table called EBA_DEMO_IG_EMP and DEPT table called EBA_DEMO_IG_DEPT. Each of these tables have a few extra columns that are helpful in demonstrating the editing capabilities of Interactive Grid.

To demonstrate various paging strategies and how larger datasets are handled another table called EBA_DEMO_IG_PEOPLE is used. This table is based on data from the Pantheon dataset: Yu, A. Z., et al. (2016). Pantheon 1.0, a manually verified dataset of globally famous biographies. Scientific Data 2:150075. doi: 10.1038/sdata.2015.75. It is a list of important historical people. The rating column is the Historical Popularity Index (see the web site for details of how this is calculated). The data is a subset of the Pantheon dataset with additional data, specifically death date and Wikipedia URL, extracted from Wikipedia.

Getting Started

Run the application as a developer; at the bottom of the page will be buttons for viewing the page in the Oracle Application Express Application Builder. Click on the "Edit Page" button to see how the pages are defined.

Use the Next/Previous buttons at the top of the page to go through all the examples in order or use the side navigation to jump to a particular example.

If you have questions, ask them on the OTN Forum.

Features

• Basic Read-only
• Column Groups
• Add Toolbar Button
• Row Header
• Sequence Row Header
• Multiple Selection
• Saved Reported
• Linking to Interactive Grids
• Single Row View
• Icon and Detail View
• Traditional Paging
• Traditional Paging (Total Rows)
• Traditional Paging (Custom)
• Traditional Paging (Custom)
• Traditional Paging (Select List)
• Scroll Paging
• Load More Paging
• Basic Editing
• Validation