Hi All,
I have an issue with Interactive Report with checkbox. The query for the IR is like below:
SELECT APEX_ITEM.checkbox2 (1, deptno, p_attributes => 'class="deptno_cb"') "Select",
deptno,
dname,
loc
FROM dept
WHERE deptno = NVL ( :p16_department_list, deptno);
Oracle apex page has a select list at the top of the page. On selecting a list value, IR report updates. Select list dynamic action refreshes the IR region.
Page Javascript in "Function and Global Variable Declaration" has below code to restrict user to select/check one checkbox at a time.
$('#object_details_static_id input[type=checkbox][name=f01]').on('change',function(){
$('#object_details_static_id input[type=checkbox][name=f01]').not(this).prop('checked',false);
});
The issue is, when I change the select list value, user can select more than one checkbox.
When I refreshes the browser , page(checkbox) works fine and page restricts user to select only one checkbox at a time.
I was expecting above javascript code would restrict user to select only one checkbox at all times but it is not happening when I change the select list value. I have to refresh the browser to make the page work.
Am I doing anything wrong here. I am new to Oracle Apex. Any help would be much appreciated.
Thanks