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:
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:
Tell me how to do it right?