Document Generation: Hyperlinks in Oracle DB

[Andreas Morgenstern]

Hi,

I'd like to insert hyperlinks into a custom sql fragment within the document generator but I fail
on an oracle DB. Did anyone use a custom sql fragment on a oracle database and can
tell me what todo?

Andreas


E.g.  I've tried the following SQL-fragment taken from Sparx EA Documentation:

Code: [Select]

SELECT t_object.ea_guid CONCAT t_object.Name

     AS [BaseClassName.Hyperlink]

     FROM t_object, t_connector

     WHERE t_connector.Start_Object_ID = #OBJECTID#

     AND t_object.Object_ID = t_connector.End_Object_ID

     AND t_connector.Connector_Type = 'Generalization'
Unfortunately, what I get is (translated from german):
Keyword FROM not found at expected place ...

[philchudley]

Hi

Try the following

SELECT t_object.ea_guid CONCAT t_object.Name

     AS "BaseClassName.Hyperlink"

     FROM t_object, t_connector

     WHERE t_connector.Start_Object_ID = #OBJECTID#

     AND t_object.Object_ID = t_connector.End_Object_ID

     AND t_connector.Connector_Type = 'Generalization'

Phil

[hd]

As well as replacing the square brackets with double quotes, CONCAT could also be the problem. Maybe ...

Code: [Select]

SELECT CONCAT(t_object.ea_guid, t_object.Name)or...

Code: [Select]

SELECT t_object.ea_guid || t_object.Nameor...

Code: [Select]

SELECT t_object.ea_guid, t_object.Name

[Eve]

Version 13 can help with this, as it added an escape sequence to abstract out the database dependencies for concatenation for custom sql searches and fragments. The following should work for any DB we support.

#Concat t_object.ea_guid, t_object.Name#

PS. I've asked to get this included in the help.

[Andreas Morgenstern]

Hi,

thanks for your help. It works. A minimal working example that just returns a hyperlink to the currently processed object is:

Code: [Select]

SELECT (CONCAT (t_object.ea_guid,t_object.Name)) AS "Name.Hyperlink"
FROM t_object
WHERE t_object.Object_ID = #OBJECTID#
Yours

Andreas