How to Count the Character and Word of the Rich Text item in Oracle Apex

Add The following Code On the JavaScript Initialization Code Of Your Item. function(options) { options.executeOnInitialization = function(editor) { const plugin = editor.plugins.get(‘WordCount’); editor.sourceElement.parentElement.parentElement.appendChild(plugin.wordCountContainer); }; return options; }

Oracle APEX – make a field conditionally required

As you have probably found, you cannot just set the dependent item’s Required attribute, as this makes it required even when hidden. Instead you can create a Validation of type “Item is NOT NULL” on the dependent item, but with a server-side condition based on the value of the other item. For example, suppose the […]

Shared authentication across multiple APEX applications

http://www.grassroots-oracle.com/2014/04/shared-authentication-across-multiple-apex-apps.html

Resolve “Session State Protection Violation” Error in Oracle Apex

https://www.foxinfotech.in/2020/01/resolve-session-state-protection-violation-error-in-oracle-apex.html

Session state protection violation: This may be caused by manual alteration of protected page item P19_*******

Resolve Session State Protection Violation Error for Display Only and Read-Only items We use Display Only and Read Only items so that the user can not edit the field values at runtime. But if you are updating the values programmatically using the JavaScript then rather than setting it from Oracle Apex as Display only or Read-only, it is better to set […]

Displaying Multiple Columns in Oracle APEX Popup LOV

CLICK

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

CLICK HERE

Displaying the File Type Icon in Oracle APEX Reports

CLICK HERE

Oracle APEX Bar Chart Colors (Conditional)

Step 1: Create a new blank page. Step 2: Create a bar chart region and your bar chart series query would then look something like this, ————————————————————————————— select null,STATUS as STATUS, case when STATUS = ‘VACANT’ then ‘#d1f5e0’ –light green when STATUS = ‘ALLOCATED’ then ‘#fff4dd’ –light orange when STATUS = ‘MAINTENANCE’ then ‘#fdd5cc’ –light red else […]

APEX