Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Grid - Disappearing Hamburger Column when using jQuery IG api

Matt McGeeAug 25 2021 — edited Aug 27 2021

I have built out a proof of concept interactive grid where we allow users to edit data in configuration tables. I'm utilizing the plsql return function query source and am renaming and sorting the columns on the fly with jQuery. I have pretty much accounted for everything however, when I execute the jQuery, the APEX$ROW_ACTION (hamburger menu column) disappears and I cannot seem to keep it once the jQuery fires. Anyone have a solution?
We are running APEX 20.2
This is what I am firing after the page loads. It is generated by PL/SQL via AJAX call.

$(document).ready(function () {
    var Grid_1 = apex.region("aaGridEdit").widget().interactiveGrid("getViews").grid;
    Grid_1.view$.grid({
        "editable": true,
        "columns": [{
                "VC1": {
                    "heading": "Batch Mask",
                    "seq": 1
                },
                "VC2": {
                    "heading": "Autobatch Method",
                    "seq": 2
                },
                "VC3": {
                    "heading": "Descr",
                    "seq": 3
                },
                "VC4": {
                    "heading": "User Id",
                    "seq": 4
                },
                "LOV1": {
                    "heading": "Setofbooks",
                    "seq": 5
                },
                "LOV2": {
                    "heading": "Auto Close",
                    "seq": 6
                },
                "LOV3": {
                    "heading": "Auto Settle",
                    "seq": 7
                },
                "VC5": {
                    "heading": "Email Address",
                    "seq": 8
                },
                "LOV4": {
                    "heading": "Batch Type",
                    "seq": 9
                }
            }
        ]
    });
    Grid_1.view$.grid("refreshColumns").grid("refresh");
});
This post has been answered by Oleh Tyshchenko on Aug 28 2021
Jump to Answer
Comments
Post Details
Added on Aug 25 2021
4 comments
97 views