How to freeze a column in interactive grid in oracle apex

Question

I have a interactive grid with many columns. I want a certain column to be always placed at first position in the row.

**Has Role**   Name   User_ID  Address   Phone number

Basically I want to freeze the column 'Role' so that user can not change its position in runtime. He can change the positions of others columns like Name, USER_ID, Address, Phone number.

How can I achieve this ?

AWildmann AWildmann · Accepted Answer · 2019-02-11T12:07:13

**EDIT - New answer. I edited the previous answer, because it would be too long to fit in a comment.

I suppose you could freeze that column and disable the freeze/unfreeze option in the header with the following. Keep in mind, this disables the freeze options on the whole interactive grid. Add it to the Execute when Page Loads section.

$("#ig_id").on("gridactivatecolumnheader", function(e){
    setTimeout(function() {
        $("#ig_id").find("[data-option='freeze']").remove();
    },
               1);
}
            );

To do it on a single column, go to it on its column on the advanced section, and add the following in the JavaScript Initialization Code. You'll basically deactivate the header actions menu form appearing, thus not allowing people to change it's freezing options. Not sure though if the order can be changed. I haven't tested that. I'll give it a try here as well.

function(config) {
    config.defaultGridColumnOptions = {
        noHeaderActivate: true
    };  
    return config;
}

How to freeze a column in interactive grid in oracle apex

2 Answers