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 #73: Passing data to parent page using close dialog items to return
This week's tip on passing data to parent page using close dialog items to return is...
Read moreAPEX Instant Tip #72: A Recommended Accessibility Audit
Special guest Hayden Hudson shows how to begin testing your website for accessibility using your Tab...
Read moreAPEX Instant Tips #71: Row level security in Interactive Grids: Did you know?
You can allow for different operations (Update, Delete, Update&Delete, Read Only) on the different rows in...
Read moreAPEX Instant Tips #70: Save Time with Cross-Page Utilities
Hayden shows how to speed up applying authorization schemes to pages by using the "grid edit...
Read moreAPEX Instant Tips #69: How to use that browser web service from inside your database
Anton's and Hayden's thought processes as they turn a browser-based web service call into a database...
Read moreAPEX Instant Tips #68: Feature creep in a good way: more fun with the APEX Standards Application
Digging into the Metadata of APEX and the Database itself with the APEX standards tracking application...
Read more