Overview
By default, the IR region allows to either enable the Download button to all users or disable the Download button to all users. Suppose if there is a requirement to enable/disable the download button based on user role, then we need to go for customization.
Architecture
Let’s see how to achieve from the following steps,
Step 1: Create an Authorization scheme to validate the user role returning Boolean type,
Shared Components → Security → Authorization Schemes → Create
Name : GET_USER_ROLE
Type: PL/SQL Function Returning Boolean.
Code:
CREATE OR REPLACE FUNCTION has_roles (prole IN VARCHAR2)
RETURN BOOLEAN
IS
role_details ROLES%ROWTYPE;
BEGIN
SELECT *
INTO role_details
FROM ROLES
WHERE ROLE = prole;
IF role_details.ROLE = ‘ADMIN’
THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
Step 2 : Assign a Static ID to interactive report,
Step 3 : Create a Dynamic action,
Event :- Click
Selection Type :- jQuery Selector
jQuery Selector :- #STATIC_REPORT_ID_actions_button
Security → Authorization Scheme :- GET_USER_ROLE
Action :- Execute Javascript Code
Code :-
setTimeout(function(){
$( “.icon-irr-download” ).parent().parent().parent().parent().prev().remove();
$( “.icon-irr-download” ).parent().parent().parent().parent().remove();
}, 100);
Step 4 : Screen looks like below image when Admin user logs into the application,
Steps 5 : Screen looks like below image when Support user logs into the application,
