Press "Enter" to skip to content

APEX Interactive Grid Cookbook

Last updated on Monday, July 24, 2017

[This app has been updated]

At Kscope17 I gave a presentation called “APEX 5.1 Advanced Interactive Grid” that showcased many examples of whats possible with APEX Interactive Grids once you get into advanced customization. I didn’t show how the examples were implemented. I could go deep on one or two examples or show many and I choose to show as many as I could (and still have time to talk about future IG stuff). But I promised to make the IG Cookbook app available so here it is ready to download. I may add to it over time and announce updates on twitter and/or this blog.

There isn’t much to explain about this here because extensive notes are provided on each example page and there are some comments in the code as well. Some of the examples were inspired by questions from the APEX forum.

Feel free to discus the techniques shown in this app or issue with this app on the APEX Discussion Forum. This is not an officially supported sample but I’ll reply if possible and you can all help each other as well.

13 Comments

  1. John Snyders
    John Snyders Monday, August 7, 2017

    Again: The tables come from the Sample Interactive Grids app. You need to install that first. The first page of IG Cookbook explains that.

  2. Saifuddin
    Saifuddin Monday, August 7, 2017

    table or view does not exist .. ? Where to get database tables

  3. Dennis
    Dennis Monday, July 31, 2017

    When I install this I get
    ERROR at line 1:
    ORA-02291: integrity constraint (APEX_050100.WWV_FLOWS_FK) violated – parent
    key not found
    ORA-06512: at “APEX_050100.WWV_FLOW_API”, line 3047
    ORA-06512: at line 2

  4. John Snyders
    John Snyders Thursday, July 27, 2017

    @David, You can see the initial splitter position hard coded to 300 in the Splitter region template. You can change that. I Theory ti could be made a template option with values small/medium/large. It should remember the splitter position like the ones in page designer but that is more work. It already resizes dynamically so not sure what you are looking for. You can set the position option with JavaScript at runtime just like you would any jQuery UI widget option.

  5. Franco
    Franco Thursday, July 27, 2017

    Amazing work, thank you!

  6. David
    David Thursday, July 27, 2017

    Many thanks John, the use of the splitter on Page 17 is exactly what I was looking for. However, I can’t work out how to control the X position of the right hand splitter using Javascript (I am trying to get it to resize dynamically) and how to define its original X position – any thoughts ?

  7. John Snyders
    John Snyders Thursday, July 20, 2017

    The tables come from the Sample Interactive Grids app. You need to install that first. The first page of IG Cookbook explains that.

  8. colin
    colin Friday, July 14, 2017

    Same issue for me, table or view does not exist,

  9. Waqar Siddiqui
    Waqar Siddiqui Wednesday, July 12, 2017

    Thank you for this.

  10. ZISHAN
    ZISHAN Tuesday, July 11, 2017

    table or view does not exist .. SO FROM WHERE I GET THE TABLES?

  11. Georg Breazu
    Georg Breazu Tuesday, July 11, 2017

    Danke John!

  12. Jos Dols
    Jos Dols Tuesday, July 11, 2017

    Best timing ever John, just at the start of my holiday! Lot’s of time to study.
    Thank you

  13. Alan
    Alan Monday, July 10, 2017

    Thanks John. Very helpful.

Comments are closed.