Home
Featured
mega/slider

How to Use Select All box in Interactive Report Oracle Apex

interactive report, How to Use Select All / Unselect All Checkbox in Interactive Report and Delete Select row Oracle Apex
How to Use Select All box in Interactive Report Oracle Apex
Select All / Unselect All Checkbox in Interactive Report and Delete Select row Oracle Apex <iframe allowfullscreen="" class="BLOG_video_class" height="356" src="https://www.youtube.com/embed/mEy3Qn4Kv6E" width="604" youtube-src-id="mEy3Qn4Kv6E"></iframe> 1. Create Region and Interactive Report 2. Use the following code inside the report code select  LOG_ID,  LOGIN_USER,  IP_ADDRESS,  LOGIN_TIME,  LOGOUT_TIME,  LOG_DATE, apex_item. hidden ( 01 ,LOG_ID)|| apex_item.checkbox2( 02 ,LOG_ID) check1 from  USERS_LOG 3. Use the following code in the heading of the CHECK1 item <input type="checkbox" id="selectUnselectAll" title="Select/UnselectAll"> 4. Disable the Escape special characters option from the Security option of the CHECK1 item 5. Enter the Static ID = partnerslRR from Advanced as you like in the report 6. Create Dynamic Action >> Event >> Chang >> Selection Type >> jQuery Selector  …

1 comment

  1. Anonymous
    ADD- $('#selectUnselectAll').click(function () {
    $('input:checkbox').prop('checked', this.checked);
    }); in Function and Global Variable Declaration of the page. Defect on single checkbox fixed with this.