Tech, Oracle, user experience, coffee, design standards, and shameless ranting

oracle apex checkbox select all

Recently I needed to add a check box column to an interactive

report on Oracle 4.2.

I used the APEX_ITEM functionin my report’s SQL to generate the checkbox, but I needed a Check All option on the column header.

Simple, just rename the column header:

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

This was implemented after repeated requests in Apex 3.

Works a treat.

I have a delete button which ive placed to the right of the interactive report bar. and it submits the page where i have a process deleting the related records:

FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
DELETE FROM document WHERE resid = APEX_APPLICATION.G_F01(i);
END LOOP;

All good.
image

Share
  • what if we want 2nd column to be checked

  • I’m afraid this only works on the first column, you’ll have to roll your own i’m afraid.

You can follow any responses to this entry through the RSS 2.0 feed.

Switch to our mobile site