Hello everyone,
i'm new to oracle apex. i'm stuck on a little point in dealing with checkbox in classical report to update status to Y or N in PLSPL using for loop please guide me. code is as below
Select
ID,
STATUS,
'<input type="checkbox" name="F01" class="confirmcheckbox" onclick="apex.item(''P14_ID'').setValue('''||ID||''');
apex.item(''P14_STATUS'').setValue(''||STATUS||'');" value="Confirm" id="shoukatCheckbox">' as "CHECKBOX",
NAME
from ALLUSERS where Status= 'N' order by 1;
getting data to show in report
FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
UPDATE ALLUSERS Set STATUS='Y' where ID=:P14_ID;
END LOOP;
update data on click of sava button
i want to select multiple checkbox and hit Save button to run a dynamic action to update status to "Y" of all row with selected checkbox.
Oracle Apex 18.2
Regards,
Noman Hameed