CODEWITHSUNDEEP
oracle-databaseoracle-apex
Velocity
Velocity

Reputation: 475

Oracle Apex Change link column color

I have Interactive report in apex application where first column USER_GID includes links or is a link column.

How do i change the color of the link?

enter image description here

Here column USER_ID contains links.

So 23, is a link and i want to change its color to blue.

So the links are distinguished.

How can i do that?

Apex 20.2

Upvotes: 0

Views: 1399

Answers (1)

Littlefoot
Littlefoot

Reputation: 143083

As I don't have your table, I used Scott's EMP. The idea is: if DEPTNO column represents a link (I used the one to Google), paint it differently for each department number.

Interactive report's query would then look like

select 
  '<a href="https://www.google.com" style="color:' ||
    case when deptno = 10 then 'red'
         when deptno = 20 then 'green'
         else 'pink'
    end  ||
    '">' || deptno || '</a>' detpno,
  --
  empno, ename, job
from emp
order by ename

Don't forget to set deptno column's "Escape special characters" property to "No".

The result is then

Upvotes: 2

Related Questions