Search code examples
oracle-databaseoracle11goracle10gobiee

How to set up a test in OBIEE as a hyperlink?


There is such an SQL request:

Select 
(((('<a href="https://help.company.ru/sd/operator/#uuid:serviceCall$'::text || scall.id) || '">'::text) || (scall.title)::text) || '</a>'::text) AS call_link

Produces this result:

enter image description here

In the next step, I connect to OBIEE 12c, do the analysis and set up the text as a hyperlink, but it does not work out correctly:

enter image description here

Tell me how to do it right?


Solution

  • This can be accomplished by selecting the HTML format under Column Properties > Data Format:

    screenshot