Oracle Apex Interactive Grid: Create Custom Add Edit Save and Delete Buttons

27 Comments

1. Hello, how would it be to add a button to do a custom filter.
   For example, the filter in an employees table is:
   State = 'New York'

   • To do this, you can add a static region above the interactive grid.

     Then add a list item and specify the source, for example:

     Select state d, state r from state_master order by state
     

     Add a where clause to your IG, for example:

     Where state = nvl(:Px_LISTITEM, state)
     

     Create a dynamic action on the list item for change event. Select the action as Refresh, select type as Region and specify your IG region.

     It should work as you need.

   • Hi Vinish,
     I have created an item of type Popup LOV with static values ​​in the static region.
     Associate a DA to the "change" event of the PopupLOV item.
     DA has a "Refresh" event for the region that contains the IG

     "Refresh" event is executed fine every time I change value in PopupLOV
     But in the SQL code of the IG it does not bring the value chosen in the PopupLOV.

     I also tested it with a simple SQL and it shows it as null.

     DECLARE

     BEGIN
       Apex_debug.message ('VALUE OF P29_STATE1 ' ||: P29_STATE1);

     END;

     (: P29_ESTADO1 is the PopupLOV item)

     Any ideas ?

   • In your above code, I can see a space between colon and item name why?

     It should be only :P29_STATE1

     One more thing: in ITEMS TO SUBMIT please add the item P29_STATE1

     You will find this property below where clause of interactive grid.

     Try this and let me know.

   • There was no space, I leave it like this the copy / paste.

     I work fine defining the ITEMS TO SUBMIT as P29_STATE1

     Thank you very much

2. Hello , i had to use an interactive Grid , and i want to use PLSQL code to process some columns before inserting them (eg concat first name+last name and insert in as a full name in DB ) .Do you have an example of this kind of code ( for inserting multiple values at the same time ) .Thanks

   • You should use before insert database trigger for your requirement.

     You will be easily able to manipulate data before insertion.

3. Thanks for all this. I wanted to just add the Add and Save buttons. However, when I enter the Javascripts lines for these, the page doesn't display anymore. If I leave just the script out but keep everything else it's fine. I'm using Apex 19.2 so is the JS code the same?

   • Yes the JS code is same.

     You need to find the exact error. At runtime, if any error on the page, it shows the red icon bottom of the page.

     Try to inspect element and click on the console tab, there you will get the full error information.

     Then let me know, what exactly the error is.

   • Thanks for the quick reply. I'm fairly new to Apex so could easily be making a mistake somewhere. After opening the console, I see this error, which is pretty non-desciptive as jQuery in loaded in min mode.

     desktop_all.min.js?v=19.2.0.00.18:formatted:1551 Uncaught TypeError: Object.defineProperty called on non-object
         at Function.defineProperty (<anonymous>)
         at Y.cache (desktop_all.min.js?v=19.2.0.00.18:formatted:1551)
         at Y.get (desktop_all.min.js?v=19.2.0.00.18:formatted:1567)
         at Object.add (desktop_all.min.js?v=19.2.0.00.18:formatted:1944)
         at Boolean.<anonymous> (desktop_all.min.js?v=19.2.0.00.18:formatted:1912)
         at Function.each (desktop_all.min.js?v=19.2.0.00.18:formatted:146)
         at k.fn.init.each (desktop_all.min.js?v=19.2.0.00.18:formatted:74)
         at Ae (desktop_all.min.js?v=19.2.0.00.18:formatted:1911)
         at k.fn.init.on (desktop_all.min.js?v=19.2.0.00.18:formatted:2215)
         at Object.<anonymous> (desktop_all.min.js?v=19.2.0.00.18:formatted:8772)
     

     The JS code I've added is

     apex.region( "ig_groups" ).widget().interactiveGrid( "getActions" ).invoke( "selection-add-row" );
     

     I've also added some (combined) screenshots of the design to see if I've put thngs in the right place. Hope it helps 🙂

   • Oh got it. Your dynamic action for the button is wrong.

     You didn't follow the instructions. Now do these things:

     Delete the DA ADDR.

     Then do the right-click on your ADD button and select the option Create Dynamic Action.

     A true action by default will be created, change it to Execute JavaScript code.

     Then add the following JavaScript code in it:

     apex.region( "ig_groups" ).widget().interactiveGrid( "getActions" ).invoke( "selection-add-row" );
     

     Do only what I mentioned, it will be ok.

   • Hi Vinish,
     Many thanks for that, I'll give it a try. BTW, the DA_ADDR is there from one of your other excellent tutorials and you don't explicitly say attach the js code to the True action. Keep up the good work though, it's brilliant for novices like myself, particularly in my case where I didn't want the standard controls to confuse the end user.

   • Oh ok and sorry if I didn't explained well in any of my tutorial.

     Actually, your DA selection type was wrong. It should be the button but it was selected as JavaScript expression.

     But if you still face any issues, please let me know.

4. Hello, is there a way to implement it in all of my tables? Without create it manually everytime. Like DRY.

5. Hello,
   Thank you for this usefull post. I need help please :
   I have a intercative grid with my Save button. I would like to hide this button if the IG is empty and show it if the IG return rows. How can I do please ?

   • Hello,

     I have written this code :

     var selectedRecords1 = apex.region("GRID_ID").widget().interactiveGrid("getViews","grid").getSelectedRecords();
         if (selectedRecords1.length == 0)
         {
             $x_Hide("Button");
         } else {
             $x_Show("Button");
         }

     But the problem is that It doesn't work with any event and I tried them all !

     Any help please ?

     Thanks

   • Finally, this is the solution :
         
         var model = apex.region("tab_ir").widget().interactiveGrid("getViews","grid").model;

         lcount = model.getServerTotalRecords();

         alert("Nombre total de lignes : " + lcount);

         if (lcount > 0)
         {         
             $x_Show("btn_id");
         } else 
         {
             $x_Hide("btn_id");
         } 

     and it works !

6. Hi,
   Thank you for your detailed solution, helps a lot for newbie like me.

   I have a page with custom search button which populates 2 independent Interactive grids (IGs).
   I had used igutils.js plug-in earlier when I had search and one Interactive grid - which works great. When I make a change in the grid and hit search button instead of save, it will show a popup, do you want to save your changes....

   This does not work with 2 IGs. Any solution is greatly appreciated.

   Thanks,
   Oscar.

7. I am not able to see Button Position: Copy while creating new custom butto

8. i made the same thinks like you did in the Tutorial but i get a Error code:

   Ajax call has server error ORA-20987: APEX - ORA-01031: Insufficient permissions - Contact the application administrator. For details about this incident, see debugging ID "2838030". returned for.

   Maybe some one can help me

9. what is the query for fetching the data based on user input on the form and after clicking the button save, data will display on the interactive grid? thanks

10. Hi Vinish,

    I'm working on Apex 20.1.
    I did not found delete button with IG hence I used your code. And I created delete button only.
    Now delete button is working fine before saving the record. Although it still throws javascript error "Cannot read property 'length' of undefined".

    But the main problem is after saving records, I'm not able to update any record. So, after row selection if I click on Delete button, nothing happens.

    Please help.

11. Hello,

    Similarly shall we add the custom search bar and Actions which are available under Grid toolbar?

    Thanks

12. Hello,

    Thanks for the solution

    how to hide only the default Add/Edit/Save & Delete buttons but not the search All text columns(Search Bar) and Actions one.

    Thanks

13. Hello,
    How to record the rows deleted by Apex 19.2 IG in the audit table of the Oracle database.

14. I just need the add and delete button for now.

    I created my ig.
    static id = ig_FixedAmt

    Created a button called Add
    Created a button called Delete

    Right clicked on the Add button
    Create a dynamic action named AddClicked
    Action: Javascript Expression
    Code: apex.region( "ig_FixedAmt" ).widget().interactiveGrid( "getActions" ).invoke( "selection-add-row" );

    Right clicked on the Delete button
    Create a dynamic action named DeleteClicked
    Action: Javascript Expression
    Code: apex.region( "ig_FixedAmt" ).widget().interactiveGrid( "getActions" ).invoke( "selection-delete" );

    Save - run page - click on add button: 1 row is added.
    click the Add button again without entering any data (because I know my users will do that) and I get this error:

    Uncaught TypeError: Cannot read properties of null (reading 'fields')
    at a..._deactivateCell (interactiveGrid.min.js:11)
    at a..._deactivateCell (desktop_all.min.js:27)
    at a...focusin (interactiveGrid.min.js:9)
    at HTMLDivElement.h (desktop_all.min.js:27)
    at HTMLDivElement.dispatch (desktop_all.min.js:2)
    at HTMLDivElement.v.handle (desktop_all.min.js:2)
    at Object.trigger (desktop_all.min.js:2)
    at Object.simulate (desktop_all.min.js:2)
    at HTMLDocument.i (desktop_all.min.js:2)
    at a..._setFocus (interactiveGrid.min.js:11)

    • Add one more True action for Add button to hide that button. And on page submit create a DA to show it.

Comments are closed.