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 #175: Why is my APEX item null? What is item “Storage”?
Be aware of the order of operations in APEX. Keep this in mind: Processes happen before...
Read more
APEX Instant Tips #174: Dynamic Actions and Order of Execution
Dynamic actions have brought client-side JavaScript to everyone, but it is still important to understand a...
Read more
APEX Instant Tips #173: Naming User Preferences
Anton teams up with very special guest Hayden Hudson to add a follow up on epsisode...
Read more
APEX Instant Tips #172: Region Template Best Practices
Standard? Blank with Attributes? Blank with Attributes (No Grid)? When should I use each of these...
Read more
APEX Instant Tips #171: APEX v24.2 Opening Modal Dialog Pages
When upgrading to APEX v24.2 be sure to fix custom javascript that opens modal dialog pages...our...
Read more
APEX Instant Tips #170: Find matching members in two “multi-value”, colon separated strings
A quick method to determine if two "multi-value" strings (e.g. colon separated) have any matching members.
Read more
APEX Instant Tips #169: A return to writing fast queries…and a function to make it easier.
Think you can’t learn anything valuable in 5 minutes? Anton and Marwa will prove you wrong,...
Read more
