Hayden challenges Anton to create a report for his APEX application that can expose hundreds of tables and views to the user. Anton shows him how to set up both a classic report and an interactive report that morphs to look for any table that needs to be exposed.
Useful links
Anton’s GitHub Repo
https://github.com/ainielse/rando > f_one_report.sql
Hayden’s APEX feature request
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #113: How to merge data during application deployement
Hayden describes how one can merge from the zipped static file that Data Packager creates for...
Read more
APEX Instant Tips #112: Always filter APEX views by workspace_ID
Filtering APEX views by workspace_ID has the advantage of making your results more intuitive as well...
Read more
APEX Instant Tips #111: How to masquerade as another user
Anton and Hayden demonstrate how to test authorization schemes effectively by masquerading as another user.
Read more
APEX Instant Tips #110: Debugging the JavaScript keyword “this” when used in APEX dynamic actions
Anton and Hayden discuss debugging the JavaScript keyword “this” when used in APEX dynamic actions using...
Read more
APEX Instant Tips #109: Writing Fast Queries Part 1
An overview of several tips from Anton's blog post about writing fast queries and a demo...
Read more
APEX Instant Tips #108: Basic Liquibase
Built into SQLcl for everyone to use is Liquibase. Hayden demonstrates his preferred method for its...
Read more
APEX Instant Tips #107: APEX Session Overrides
Session overrides is an APEX feature that enables you to code in local files that affect...
Read more
APEX Instant Tips #106: A few pointers on SQLcl
Using their 5 minutes to its max (and then some), Hayden and Anton discuss Formatting and...
Read more