Below are simple steps to select/unselect all checkboxes in a classic report:
1. Create a page with a classic report based on a sample query
select apex_item.checkbox(1, EMPLOYEE_ID) selectemp,
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
PHONE_NUMBER,
HIRE_DATE
from EMPLOYEES
2. Add static ID : emp on the classic report region
3. Add below Javascript on the page
1. Create a page with a classic report based on a sample query
select apex_item.checkbox(1, EMPLOYEE_ID) selectemp,
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
PHONE_NUMBER,
HIRE_DATE
from EMPLOYEES
2. Add static ID : emp on the classic report region
function handleClick(cb) {
if (cb.checked === true) {
$('#emp input[type=checkbox][name=f01]').prop('checked',true);
} else {
$('#emp input[type=checkbox][name=f01]').prop('checked',false);
}
}
4. Change the heading on the SELECTEMP column of the report to below
5. Ensure you set 'Escape Special Characters' on the SELECTEMP column to 'No'
6. Run the report and see the changes when you select/unselect the checkbox in the heading
Happy APEX Experience
How we can select using radio button in IR?
ReplyDeleteI have an IR and want to implement and radio button and do some dml action on selected record