1. Overview
This document talks about how we can achieve the custom column heading tooltip in Interactive report.
2. Technologies and Tools Used
The following technologies has been used to achieve the expected output.
- Oracle APEX
- Java Script
3. Use Case
Interactive report doesn’t have the inbuilt feature to view the column headings tooltip.
4. Architecture
Steps below to add this customization in interactive report.
First add help text to your interactive report columns in help text position.
Next create page process to Process Point “On Load -After Header”.
DECLARE
l_sql VARCHAR2(32700);
BEGIN
l_sql := ‘
SELECT COLUMN_ALIAS,
HELP_TEXT
FROM APEX_APPLICATION_PAGE_IR_COL
WHERE APPLICATION_ID = :APP_ID
AND PAGE_ID = :APP_PAGE_ID
AND HELP_TEXT IS NOT NULL
‘;
HTP.p (‘<script type=”text/javascript”>’);
— Create JSON object.
HTP.prn (‘var gIrColHelp = $u_eval(”(‘);
APEX_UTIL.JSON_FROM_SQL(l_sql);
HTP.prn (‘)”);’);
HTP.p (‘</script>’);
END;
Create dynamic Action. Select Advanced
- Name: Set Column Headings Title
- Event: After Refresh
- Selection Type: Region
- Region: {select your report region}
- Condition: No Condition
- Action: Execute JavaScript code
- Fire On Page Load: True
- Selection Type : None
- Code
$.each(gIrColHelp.row,function(i,jd){
$($x(jd.COLUMN_ALIAS)).attr({“title”:jd.HELP_TEXT});
});
5.Conclusion
