I’ve blogged quite a bit on the Interactive Grid and the vast array of features; some features are technically available for use in your applications however they are not documented – more on what this means later.
Before I dig in, let’s not forget the Interactive Grid was undocumented on launch on APEX 5.1. Even though we have several blogs from the APEX team, it wasn’t until several months later that the beta documentation arrived in the expected JSDoc format.
I wouldn’t be able to advise you on whether the examples I will introduce will make the final documentation, simply remain undocumented, be replaced by alternatives or will be removed completely.
Ultimately this is the risk if you use an undocumented feature; that, upon upgrade, the plug is pulled leaving you with no alternatives. Perhaps, due to this, you’re forced to keep on the same APEX version (preventing future upgrades). If you go this route and ever need support, well you’re using an undocumented feature, and therefore your support is compromised.
Now you know the risks… let’s investigate the Interactive Grid with a focus on the Filter features. From what we discover, this may help us to understand what features are being worked on, possibly available in the future or perhaps that’s just wishful thinking.
One last caveat … John Snyders, the primary developer for Interactive Grid, regularly surrounds these undocumented features with the line.
/*** FOR INTERNAL USE ONLY: Subject to change in the future, please do not use! ***/
I’m going to introduce 4 features here, but more are available to be discovered in the widget.interactiveGrid.js file which available in your APEX download zip.
The first undocumented feature is addFilter. This allows you to add filters to the Interactive Grid, the options above are pretty much self-explanatory. Here I’m putting a Last Name filter of Mulvaney on the Grid. Interestingly you can add several filters of the same name here.
Next is getFilters which returns an array of filters. From which you can see more information about the filters that are applied on your Interactive Grid including a Filter ID.
Next up is deleteFilter. By passing a filter ID (obtained above) you can delete a filter from the Interactive Grid.
If you would like to see some examples yourself… you can follow along on my handy example application.
Author: Matt Mulvaney
Job Title: Senior Oracle APEX Development Consultant
Bio: Matt is an experienced APEX solution designer having designed numerous complex systems using a broad range of Oracle Technologies. Building on his previous experience of Oracle Forms & PL/SQL, he is entirely focused on providing functionally rich APEX solutions. Matt promotes APEX as a software platform and openly shares best practises, techniques & approaches. Matt has a passion for excellence and enjoys producing high quality software solutions which provide a real business benefit.