Thursday, 22 October 2015

Select all Checkboxes in IR - APEX 5

If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.

5 comments:

  1. Alejandro Ortiz Vivas14 January 2016 at 20:59

    it´s work fine for me

    ReplyDelete
  2. Hi Denes,

    some improvements it this bug ?

    I would like to use fixed headers stuff but i need to have some checkbox in IR too.

    reagrds

    J

    ReplyDelete
  3. Hi,

    You have to define "percent graphic" as type in the dedicated column properties.

    ReplyDelete
  4. Hi,

    another approach, even works with fixed headers:

    <input type="checkbox" onclick="javascript:$f_CheckAll(this, this.checked, $('[name=f01]'));">

    In my case, i'm using this with checkbox columns generated with APEX_ITEM.CHECKBOX2. You have to replace the f01 with the correct sequence of your checkbox column. APEX_ITEM.CHECKBOX2(1, null) => f01, APEX_ITEM.CHECKBOX2(10, null) => f10.

    Regards,
    Jens

    ReplyDelete
  5. In addition to Jens' answer, I also needed a all-on/all-off checkbox header on a IR report with fixed headers.

    Jens' is actually nicer than mine... but nevertheless, here is my solution:


    I change the heading of checkbox column in the IR report to:

    input id="select-all" type="checkbox" onclick="
    $('#select-all').click(function(event){
    var chkst;
    chkst=this.checked;
    $(':checkbox').each(
    function(){
    this.checked=chkst;
    }
    )
    }
    )"



    Regards
    Wouter

    ReplyDelete