Search This Blog

Monday, February 5, 2018

How to Make A Check Box and Check mark Individual or Multiple In Oracle Apex 5.1


1.
select  
column1, column2, column3,
APEX_ITEM.CHECKBOX(10,'#ROWNUM#') "CHKBOX" 
from  TABLE_NAME


Go to Report Attributes ->(Respective Check Box) Column Attributes->Display As -> Standard Report Column

Go to Report Attributes ->(Respective) Column Attributes->Display As -> Display as text

2.
declare
V_ROW NUMBER;
begin
FOR i IN 1..APEX_APPLICATION.G_F10.COUNT LOOP

V_ROW := APEX_APPLICATION.G_F10(i);

update TABLE_NAME
set 
Column3='Y' 
where column1=APEX_APPLICATION.G_F01(V_ROW);

--RAISE_APPLICATION_ERROR(-20001,APEX_APPLICATION.G_F08(v_row)||v_row);
--RAISE_APPLICATION_ERROR(-20001,APEX_APPLICATION.G_F01(V_ROW));
--APEX_APPLICATION.G_F01(V_ROW)||

END LOOP;

end;


3.  Do This JavaScript

$('#P106_CHCKALL').change(function() {
    var checkboxes = $(this).closest('form').find(':checkbox');
    if($(this).is(':checked')) {
        checkboxes.prop('checked', true);
    } else {
        checkboxes.prop('checked', false);
    }
});


Go to Report Attributes and   Copy Pest it on the  Report Attribute -> Heading

<input type="checkbox" id="P106_CHCKALL" />

OR

<input type="checkbox" onclick="$f_CheckFirstColumn(this)" />


No comments:

Post a Comment

Split A String By Coma (,)

Step 1.  create or replace type split_tbl as table of varchar2(32767); Step 2. create or replace function split (     p_list varchar2,...