Posted inAPEX

Strip html using PLSQL

Referred from John’s cookbook sample app. Copy CodeCopiedUse a different Browsercreate or replace function striphtml( p_html in varchar2) return varchar2 is l_html varchar2(32767); l_pos pls_integer; begin if length(p_html) > 0 then l_html…
October 7, 2021
Posted inAPEX IG Interactive Grid

Interactive GRID | Hide Report Settings Area

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { config.reportSettingsArea = false; apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; }
October 6, 2021
Posted inAPEX Interactive Grid

Interactive GRID | Rows Per Page on Toolbar

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { var $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(), toolbarGroup = toolbarData.toolbarFind("actions1"); toolbarGroup.controls.unshift( { type:…
October 6, 2021
Posted inAPEX JavaScript

Get Device ID in Oracle APEX

How to Get Device ID in Oracle APEX? Create a page with a page item and paste below Javascript in Function and Global Variable Declaration section as per screenshots. Copy CodeCopiedUse a…
October 1, 2021