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 usi...
Item validation in oracle Apex | Apex Validation
• Item validation in oracle Apex | Apex...
How to use key focus in oracle apex | Apex tab key go to next item
• How to use key focus in oracle apex |...
page auto refresh in oracle apex | auto refresh interactive report in oracle apex
• page auto refresh in oracle apex | au...
oracle bi publisher report tutorial in oracle apex
• oracle bi publisher report tutorial i...
region selector in oracle apex (region display selector in oracle apex)
• region selector in oracle apex (regio...
How to delete oracle apex collection member
• How to delete oracle apex collection ...
How to use select2 plugin in oracle apex 19 2 (how to use plugins in oracle apex)
• How to use select2 plugin in oracle a...
Watch video How to customize interactive grid report | Oracle apex online without registration, duration hours minute second in high quality. This video was added by user Md. Mostafa Kamal 09 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,49 once and liked it 2 people.