oracle apex checkbox select all


Warning: mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO) in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10

Warning: mysql_get_server_info(): A link to the server could not be established in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10

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