AnsweredAssumed Answered

Hyperlink from Parameterized Lookup in 13.3

Question asked by Tim1302647 on Nov 20, 2014
Latest reply on Oct 21, 2015 by Dave_3.0

Following the instructions from this fantastic tip, I was able to create a hyperlink to a project's parent in Clarity 12.1.3.  However, in 13.3 the HTML code itself is displayed in the field instead of a hyperlink.  Has anyone else run into this issue?  Does anyone have any tips for resolving?

 

SELECT

@SELECT:1:DUMMY_ID@,

@SELECT:X.CALC_VALUE:CALC_VALUE@

FROM

(SELECT '<a href="'||'http://servername/niku/nu#action:projmgr.projectProperties&id='||par.id||'" target="_blank">'||par.name||' ('||par.code||')'||'</a>' calc_value

FROM inv_investments inv

INNER JOIN inv_hierarchies hier on hier.child_id = inv.id

INNER JOIN inv_investments par on par.id = hier.parent_id

WHERE inv.id = @WHERE:PARAM:USER_DEF:INTEGER:inv_id@

UNION

SELECT to_char(null) from DUAL

WHERE @WHERE:PARAM:USER_DEF:INTEGER:inv_id@ IS NULL) X

WHERE @FILTER@

 

Hyperlink 12.1.3.gifHyperlink 13.3.gif

Outcomes