Anton shares his plugin for getting Oracle APEX IG data into a page item. Once the data has been passed to the item, you can use it in Dynamic Actions, as the source for a classic report, and more.
Useful Links
Link to plugin: https://github.com/ainielse/get_ig_data
Link to Yvonne’s post on time zone handling and hours in a day: https://yvonnebakx.wordpress.com/2022/03/18/pl-sql-hours-of-day/
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