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

2 comments on this post.
  1. Siddharth:

    what if we want 2nd column to be checked

  2. Mark Caulfield:

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

Leave a comment