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!

APEX 18.1 Interactive Grid - Disabling column headers (Preventing all user customisations)

Daljit RAug 20 2019 — edited Sep 9 2019

Hi,

I'm trying to get to grips with the Interactive Grid and am creating a report that users will be using to view data only. As the report will have quite a lot of columns 30+ displayed I wish make use of one (in my opinion!) great feature of the IG and that is the ability to freeze columns. I will freeze some set column as part of my initial report set-up.

The users don't need any customisation and any exporting I will handle myself. There appears to be no single option to just disable every IG interaction i.e. a true read-only (as saved) report. Specific features are disabled individually using different approaches.

I've found the following code online that when placed into an individual columns Advanced >  JavaScript Initialization Code attribute gives me what I want in combination with disabling the actions button etc. using other methods.

function(config) {

    config.defaultGridColumnOptions = {

        noHeaderActivate: true

    }; 

    return config;

}

 

Can somebody with better JS than myself suggest the changes needed so I can achieve the same for all columns using a single JS routine e.g. at page load? So that I don't have to place the same code into 30+ columns individually and then should requirements change have to change each column again.

Thanks,

Daljit

APEX 18.1.0.00.45

DB 11.2.0.4.0

Comments
Post Details
Added on Aug 20 2019
2 comments
3,425 views