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 #149: APEX Dev Team Magic: APEX Item Plug-in
Anton and Marwa show you a magical query. No matter what type of LOV definition you...
Read more
APEX Instant Tips #148: Protect Ajax Callback processes from hacking
Last week, we made it easy to use Ajax Callback processes. This week, we show how...
Read more
APEX Instant Tips #147: Why are Ajax Callback processes so hard to use?
Ajax callbacks are hard to use: Learn the javascript and be careful about syntax. Marwa and...
Read more
APEX #146: APEX Instant Tips #146: Extending Faceted Search
Hosts Anton and Marwa talk about how to make a page item look and behave like...
Read more
APEX Instant Tips #145: How to know if the data in your Interactive Grid row changed
:APEX$ROW_STATUS is a pseudo column that can be used in PL/SQL, just like any other interactive...
Read more
APEX Instant Tips #144: When to_date
To_date, To_number, and To_timestamp stem from how APEX stores and treats Session State. Anton and Marwa...
Read more
APEX Instant Tips #143: Javascript and css from pl/sql
In this episode, Marwa and Special guest Eglé describe how to add javascript code and CSS...
Read more
APEX Instant Tips #142: LOV additional columns
Michelle sits in for Anton this week as Marwa shows you how to leverage additional columns...
Read more