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 #98: An easier way to give secure access to a REST enabled schema
Anton describes how to give access to a REST-enabled schema by simply granting the SQL developer...
Read more
APEX Instant Tips #97: What should :APP_USER contain?
For active APEX users, switching user names can be a major inconvenience. Anton recommends setting APP_User...
Read more
APEX Instant Tips #96: monitor your query with automations
In this episode, Anton and Hayden recommend trying automations when IR subscriptions don't quite meet your...
Read more
APEX Instant Tips #95: Making the most of a navigation menu
Anton and Hayden provide an efficient solution for how to replicate the redundant menu design pattern...
Read more
APEX Instant Tips #94: Creating shortcuts in APEX
Since APEX ver. 22.1 it has never been easier to create shortcuts in APEX. In this...
Read more
APEX Instant Tips #93: Using APEX App builder for design inspiration
Anton & Hayden present 5 APEX App Builder design features that can serve as inspiration for...
Read more
APEX Instant Tips #92: Using RESTful services to synch data during deployment
Struggling to deploy in APEX? REST easy, Anton and Hayden have another method to move data...
Read more
APEX Instant Tips #91: Enabling PL/SQL warnings with a logon trigger
Hayden shows Anton how to get the benefits of enabling PL/SQL warnings without a sql developer...
Read more