How to customize interactive grid report | Oracle apex
Page 2: Custom Interactive Grid Example:
Add below code for button hide on toolbar
Inline CSS
button[data-action="selection-add-row"], div[data-action="edit"] {
display: none !important;
}
===================Interactive Grid Region=================
SELECT E.EMPLOYEE_ID,
E.LAST_NAME,
EI.AMOUNT
FROM EMPLOYEES E LEFT JOIN A_INTERFACE EI ON E.EMPLOYEE_ID = EI.EMPLOYEE_ID;
==================Region Attributes=============
Enable Edit and disable button as per your requirement
Add Region Button as per your requirement
==================Settings Target Type PL/SQL Code============
BEGIN
CASE :APEX$ROW_STATUS
WHEN 'U'
THEN
INSERT INTO A_INTERFACE (EMPLOYEE_ID, AMOUNT)
VALUES ( :EMPLOYEE_ID, :AMOUNT)
RETURNING EMPLOYEE_ID
INTO :EMPLOYEE_ID;
WHEN 'U'
THEN
UPDATE A_INTERFACE
SET AMOUNT = :AMOUNT
WHERE EMPLOYEE_ID = :EMPLOYEE_ID;
WHEN 'D'
THEN
DELETE FROM A_INTERFACE
WHERE EMPLOYEE_ID = :EMPLOYEE_ID;
END CASE;
END;
==================
Apex validation | Item level validation using ajax in oracle apex
• Apex validation | Item validation using aj...
Item validation in oracle Apex | Apex Validation
• Item validation in oracle Apex | Apex Vali...
How to use key focus in oracle apex | Apex tab key go to next item
• How to use key focus in oracle apex | Apex...
page auto refresh in oracle apex | auto refresh interactive report in oracle apex
• page auto refresh in oracle apex | auto re...
oracle bi publisher report tutorial in oracle apex
• oracle bi publisher report tutorial in ora...
region selector in oracle apex (region display selector in oracle apex)
• region selector in oracle apex (region dis...
How to delete oracle apex collection member
• How to delete oracle apex collection member
How to use select2 plugin in oracle apex 19 2 (how to use plugins in oracle apex)
• How to use select2 plugin in oracle apex 1...