Within a Synonym I have a column created that builds a hyperlink to an external system. The goal is that we can include this column in a published reporting object for the end users to use, so when they use it there output will allow them to go direct to the external system. Here is an example of the define in the synonym.
The problem we are seeing is that when you pull this column into a report it encoding all of the html characters into other characters. i.e FP Mod Chuck,
WebFocus / DataMigrator 8105M
July 08, 2017, 11:23 AM
Don Garland
Used in a procedure:
DEFINE FILE CAR
QUOTE_LINK/A300 = '<a href="https://&' || '&'||'SBL_SERVER/callcenter_enu/start.swe?SWECmd=GotoView&'
|| 'SWEView=Agreement+List+View&' || 'SWERF=1&' || 'SWEHo=&' || '&' ||'SBL_SERVER&' || 'SWEBU=1&'
|| 'SWEApplet0=Agreement+List+Applet+No+Parent&' || 'SWERowId0=MODEL" target=_blank>BODYTYPE</a>';
END
TABLE FILE CAR
PRINT
CAR
QUOTE_LINK
BY COUNTRY
END