CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-5oracle-apex-5.1
Abinnaya
Abinnaya

Reputation: 223

oracle apex tooltip on report region with different values

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.

Upvotes: 2

Views: 2848

Answers (2)

Littlefoot
Littlefoot

Reputation: 143143

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

Upvotes: 1

Daniel Frech
Daniel Frech

Reputation: 335

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.

Upvotes: 2

Related Questions