Skip to Main Content
Forums

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 - hide format settings

Marc CMar 27 2019 — edited Mar 29 2019

My intention is to make an Interactive Grid (IG, not IR) more colourful for all users, by customizing the format of the IG via its User Interface Toolbar.

To make it available for all users, I do the settings via the user-interface as an administrator and then, in the end, I save the settings in the Primary Report.

I do the adjustment of the colours via Toolbar - menu Actions/Format/Highlight and then set some conditional row-highlighting.

Subsequently, a colouring schema, as I would call it, is displayed below the toolbar (much like it does for e.g. user-filter-criteria).

Though, I now want to hide the toolbar and the display of the colouring schema.

I can hide the toolbar by a setting in the APEX-builder. That works OK.

Though, I do not have a control to hide that colouring schema.

For an Interactive Report (not an Interactive Grid) , I successfully achieve the hiding by inline CSS at the page-level:

#StaticIDName_control_panel{display:none;}

by which both toolbar and colouring schema are hidden.

But such code does not work for a grid. Neither I can find a setting anywhere by which that can be controlled.

Any ideas ?
This post has been answered by John Snyders-Oracle on Mar 28 2019
Jump to Answer

Comments

John Snyders-Oracle
Answer

Hi Marc,

There is an advanced config option to turn off the report settings area.

https://docs.oracle.com/en/database/oracle/application-express/18.2/aexjs/interactiveGrid.html#reportSettingsArea

The IG Cookbook has an example that does exactly what you are trying to do. See Hide Report Settings Area. Get the cookbook here: APEX IG Cookbook Update for 18.2 – HardLikeSoftware

function(config) {

    config.reportSettingsArea = false;

    // may want to disable the highlights feature. Comment out this code to make initial highlight settings

    apex.util.getNestedObject(config, "views.grid.features").highlight = false;

    return config;

}

Note: getNestedObject is a 19.1 function. Older versions of the IG cookbook show how to do it the old way.

Regards,
-John

Marked as Answer by Marc C · Mar 28 2019
2 people found this helpful
Marc C

Brilliant! Thank you very much ! It works perfectly fine.

And thanks for the useful links. There is so much out there in APEX.

Marc

User_ETDRW

Now here's an ask.
I have a 19.2 IG with some nice colour coding / highlighting on it that I have defined.
I want users to be able to add their own filters. User should not be able to change the highlighting (I already have that disabled).
I want then to see the filters they have applied in the report settings area ... but, you guessed it, I don't want them to see the highlighting I have predefined.
Is it possible to hide just he highlighting settings within the report settings area?
Thanks
Paul

1 - 3

Post Details

Added on Mar 27 2019
#apex-discussions, #css, #interactive-grid
3 comments
6,007 views