Table of Contents

• Title and Copyright Information
• Diversity and Inclusion
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Changes in Release 23.1 for Oracle APEX End User’s Guide
• 2 About Oracle APEX
  • 2.1 Browser Requirements
  • 2.2 About Oracle APEX
  • 2.3 About Database Applications
• 3 Using Interactive Grids
  • 3.1 About Interactive Grids
  • 3.2 About Editable Interactive Grids
  • 3.3 Using an Interactive Grid
    • 3.3.1 Searching in an Interactive Grid
      • 3.3.1.1 About the Search Bar
      • 3.3.1.2 Using the Select Columns To Search Icon
    • 3.3.2 Rearranging Columns Using Drag and Drop
    • 3.3.3 Resizing Columns in an Interactive Grid
    • 3.3.4 Sorting Columns in an Interactive Grid
    • 3.3.5 Using Charts in an Interactive Grid
  • 3.4 Customizing an Interactive Grid with the Actions Menu
    • 3.4.1 Changing the Column Display in an Interactive Grid
    • 3.4.2 Filtering an Interactive Grid
      • 3.4.2.1 About Filters in Interactive Grids
      • 3.4.2.2 Creating a Row Filter in an Interactive Grid
      • 3.4.2.3 Creating a Column Filter in an Interactive Grid
      • 3.4.2.4 Editing a Filter in an Interactive Grid
      • 3.4.2.5 Disabling a Filter in an Interactive Grid
      • 3.4.2.6 Removing a Filter from an Interactive Grid
    • 3.4.3 Selecting Column Sort Order in an Interactive Grid
    • 3.4.4 Defining an Aggregation in an Interactive Grid
      • 3.4.4.1 Creating an Aggregation in an Interactive Grid
      • 3.4.4.2 Editing an Aggregation in an Interactive Grid
      • 3.4.4.3 Removing an Aggregation in an Interactive Grid
    • 3.4.5 Creating a Control Break from the Actions Menu in an Interactive Grid
    • 3.4.6 Adding Highlighting to an Interactive Grid
    • 3.4.7 Toggling Stretch Column Widths in an Interactive Grid
  • 3.5 Customizing an Interactive Grid with the Column Heading Menu
    • 3.5.1 About the Column Heading Menu in an Interactive Grid
    • 3.5.2 Displaying the Column Heading Menu
    • 3.5.3 Creating a Control Break in an Interactive Grid
    • 3.5.4 Creating an Aggregation with the Column Heading Menu
    • 3.5.5 Freezing Columns in Place
    • 3.5.6 Hiding Columns in an Interactive Grid
    • 3.5.7 Unhiding Columns in an Interactive Grid
    • 3.5.8 Filtering with the Column Heading Menu
  • 3.6 Using an Editable Interactive Grid
    • 3.6.1 Adding a Row in an Editable Interactive Grid
    • 3.6.2 Editing Rows in an Interactive Grid
      • 3.6.2.1 About the Row Actions Menu in an Editable Interactive Grid
      • 3.6.2.2 About the Edit Button in an Editable Interactive Grid
      • 3.6.2.3 Editing a Cell in an Interactive Grid
      • 3.6.2.4 Editing Multiple Rows in an Editable Interactive Grid
    • 3.6.3 Deleting a Row in an Interactive Grid
    • 3.6.4 Modifying Multiple Rows and Cells in an Editable Interactive Grid
      • 3.6.4.1 About Selection Modes in an Editable Interactive Grid
      • 3.6.4.2 Changing Selection Mode in an Editable Interactive Grid
      • 3.6.4.3 Copying to Multiple Rows in an Editable Interactive Grid
      • 3.6.4.4 Copying to Multiple Cells in an Editable Interactive Grid
      • 3.6.4.5 Filling Cells in an Editable Interactive Grid
      • 3.6.4.6 Clearing Cells in an Interactive Grid
  • 3.7 Saving Interactive Grids
    • 3.7.1 About Interactive Grid Report Types
    • 3.7.2 Saving a Report in an Interactive Grid
    • 3.7.3 Renaming a Report in an Interactive Grid
    • 3.7.4 Deleting a Report in an Interactive Grid
  • 3.8 Resetting Interactive Grids
    • 3.8.1 Refreshing an Interactive Grid
    • 3.8.2 Resetting an Interactive Grid
    • 3.8.3 How the Reset Button Affects Saved Interactive Grid Reports
    • 3.8.4 Reverting an Interactive Grid to a Specific Save State
  • 3.9 Downloading or Emailing an Interactive Grid
• 4 Using Interactive Reports
  • 4.1 About Interactive Reports
  • 4.2 Using the Search Bar
  • 4.3 Using the Select Columns To Search Icon
  • 4.4 Using the Column Heading Menu
  • 4.5 Using Interactive Report Filters
  • 4.6 Customizing an Interactive Report Using the Actions Menu
    • 4.6.1 About the Actions Menu
    • 4.6.2 Selecting Columns to Display
    • 4.6.3 Adding a Filter
      • 4.6.3.1 About Creating Filters
      • 4.6.3.2 Adding, Editing, and Removing a Column Filter
      • 4.6.3.3 Adding, Editing, and Removing a Row Filter
    • 4.6.4 Selecting Column Sort Order
    • 4.6.5 Creating a Control Break
    • 4.6.6 Adding Highlighting
    • 4.6.7 Computing Columns
      • 4.6.7.1 Creating a Computation
      • 4.6.7.2 Deleting a Computation
    • 4.6.8 Defining an Aggregation Against a Column
      • 4.6.8.1 Creating an Aggregation Against a Column
      • 4.6.8.2 Removing a Column Aggregation
    • 4.6.9 Creating a Chart from the Actions Menu
      • 4.6.9.1 Creating a Chart
      • 4.6.9.2 Editing a Chart
      • 4.6.9.3 Deleting a Chart
    • 4.6.10 Grouping Columns
      • 4.6.10.1 Creating a Group By
      • 4.6.10.2 Editing a Group By
      • 4.6.10.3 Selecting a Group By Sort Order
      • 4.6.10.4 Deleting a Group By
    • 4.6.11 Managing Pivot Reports
      • 4.6.11.1 Creating a Pivot Report
      • 4.6.11.2 Editing a Pivot Report
      • 4.6.11.3 Deleting a Pivot Report
    • 4.6.12 Executing a Flashback Query
      • 4.6.12.1 Creating a Flashback Query
      • 4.6.12.2 Editing a Flashback Query
      • 4.6.12.3 Deleting a Flashback Query
    • 4.6.13 Saving an Interactive Report
      • 4.6.13.1 About the Report List
      • 4.6.13.2 About Configuration Dependencies
      • 4.6.13.3 Saving a Public or Private Interactive Report
      • 4.6.13.4 Renaming a Public or Private Interactive Report
      • 4.6.13.5 Deleting a Public or Private Interactive Report
    • 4.6.14 Resetting a Report
    • 4.6.15 Downloading a Report
    • 4.6.16 Subscribing to Report Updates by Email
      • 4.6.16.1 How Report Subscriptions Work
      • 4.6.16.2 Subscribing to Updated Report Results
• 5 Using Tasks
  • 5.1 About Tasks
    • 5.1.1 About Task Due Dates
    • 5.1.2 About Task Participants
    • 5.1.3 About Task Actions
    • 5.1.4 About Task Details
  • 5.2 Working with Tasks
    • 5.2.1 Claiming a Task
    • 5.2.2 Approving or Rejecting a Task
    • 5.2.3 Requesting Information for a Task
    • 5.2.4 Submitting Information for a Task
    • 5.2.5 Commenting on a Task
    • 5.2.6 Changing the Priority of a Task
    • 5.2.7 Delegating a Task
    • 5.2.8 Inviting a Participant to a Task
    • 5.2.9 Updating the Due Date for a Task
    • 5.2.10 Releasing a Task
    • 5.2.11 Canceling a Task
    • 5.2.12 Renewing a Task
    • 5.2.13 Viewing the Task History
  • 5.3 About Unified Task Lists
    • 5.3.1 Searching for a Task
  • 5.4 Troubleshooting Tasks
• A Keyboard Shortcuts
  • A.1 General Keyboard Shortcuts
  • A.2 Component-Specific Keyboard Shortcuts
    • A.2.1 Date Picker
    • A.2.2 CSS Calendar
    • A.2.3 Chart Region
    • A.2.4 Map Region
    • A.2.5 Interactive Grid
    • A.2.6 Markdown Editor Keyboard Shortcuts
    • A.2.7 Rich Text Editor Keyboard Shortcuts
• Index