oracle apex tooltip on report region with different values

2
votes

I have an APEX Region, all columns of which are standard report columns. Is it possible to display a tool-tip on mouse over of a particular cell of the report?

I have 3 diff values for tat column it has to display different tooltip for all 3.

Ex: Column having values like aaa bbb ccc

if move mouse to aaa then tooltip text should be "xxx", if bbb then tooltip text should be "yyy", if ccc then tooltip text should be "zzz".

how can i perform this for column in regions.

2
oracleoracle-apexoracle-apex-5oracle-apex-5.1
please read the text associated with the apex-code tag. It has nothing to do with Oracle APEX – chrisis

2 Answers

2
votes

You could achieve this by using the global HTML title attribute by:

  • adding a hidden column (called "TOOLTIP" here) to your report that contains your tool-tip text for each row

  • and setting the HTML expression at "ColumnFormatting" => "HTML Expression" for the displayed column (called "DISPLAY" here) to:

    <span title="#TOOLTIP#">#DISPLAY#'</span>

On hover of the text in your displayed column you should now see your tool-tip text.

1
votes

This is an example based on Scott's schema. The idea is: display DEPTNO from the EMP table, but - when you put mouse over it - display DNAME from the DEPT table.

select EMPNO,
       ENAME,
       JOB,
       '<a title="' || d.dname || '">' || E.DEPTNO || '</a>' AS DEPTNO
  from emp e join dept d on d.deptno = e.deptno