Apex_Item Validation In Classic/Interactive Report Oracle APEX 5.1

Apex_Item Validation In Classic/Interactive Report Oracle APEX 5.1

Today we will learn how to raise instant error on apex item in interactive/classic report. On those cases here I have a solution on how to raise an error during on change apex item if the item would be null. To demonstrate this example, I am using the EMP table for the interactive Report.

• Create an Interactive Report Using the following Query and Go to "ENAME" column attribute in the Property Editor and define 'Escape special characters' is OFF.

select APEX_ITEM.CHECKBOX2(p_idx  =>  1,p_value  =>  empno,p_item_id       =>   'f01_'||EMPNO||'' ,p_attributes  =>'checked')||apex_item.hidden(10,empno)"SELECT",
       EMPNO,       
       APEX_ITEM.TEXT(p_idx     =>  2,p_value     =>  ENAME,p_item_id     =>   'f02_'||EMPNO||'')ENAME,
      JOB,     
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO
  from EMP
  ORDER BY ROWNUM

• Create Dynamic action on change event on an interactive report column.

•    Eevent: Change;

•   Selection Type : JQuery Selector;

•   JQuery Selector: select[name="f02"];

• Inside the change dynamic action, you will execute following  javaScript Code and specify the action fires on initialization off : 

 var colum_value = this.triggeringElement.value;
     var lov_id = this.triggeringElement.id;
    var row_id = lov_id.substr(lov_id.length - 4);
    check_1(colum_value, row_id);

Dynamic Action 

• Copy and Paste Following JavaScript Code in Function and Global Variable Declaration:

function check_1(p_val, p_row) {
apex.server.process(
'CHECK_ENAME', // Process or AJAX Callback name
{
x01: p_val
}, // Parameter "x01"
{
success: function(pData) {
// Success Javascript
if ($.trim(pData) == 'N') {
// alert($.trim(pData));
$("input#f02_" + p_row).addClass("intro");
$("input#f02_" + p_row).focus();
apex.event.trigger(document, "input#f02_" + p_row);
alert('EMPLOYEE NAME MUST HAVE SOME VALUE AGAINST ' + p_row);
} else {
$("input#f02_" + p_row).removeClass("intro");
}
},
dataType: "text" // Response type (here: plain text)
}
);
}

Function and Global variable

• Create an Ajax Call Back Process with the name "CHECK_ENAME" with the following Code.

BEGIN
   IF apex_application.g_x01 is null then
   htp.p('N');
   else
   htp.p('Y');
   end if;
   END;

Ajax Callback

• Copy and Paste bellow CSS in Inline Section:

.intro {  position: relative;
  display: inline-block;
    color: red;
  border: 1px solid ;
}

Demo

Enable/Disable Editable Interactive Report Column Based on Another Column in Oracle APEX