docs.ObjectRefCyclic - V
type: V ( view ), modify_date: 2021-11-17 11:41:55
RepoObject_guid: 87E72F09-C5FD-EB11-850F-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
sql_modules_definition
docs.ObjectRefCyclic - V script
CREATE View docs.ObjectRefCyclic
As
Select
c.cultures_name
, page_content =
--
Concat (
'= Cyclic Object References'
, Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
, '== Object List'
, Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
, elist.XrefEntityList
, Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
, '== Object Reference Diagram - Cyclic'
, Char ( 13 ) + Char ( 10 )
, '
[plantuml, ObjectRefCyclic, svg, subs=macros]
....
'
--, '\include::partial$puml/objectrefcyclic.puml[]'
, Concat (
'@startuml' + Char ( 13 ) + Char ( 10 )
, docs.fs_PumlHeaderTopToBottom ()
, elist.PumlEntityOnlyPkList
, Char ( 13 ) + Char ( 10 )
, olist.PumlObjectRefList
, Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
)
, '
....
'
)
--can be removed, if export is not required:
, ObjectRefCyclic_Puml =
--
Concat (
'@startuml' + Char ( 13 ) + Char ( 10 )
, docs.fs_PumlHeaderTopToBottom ()
, elist.PumlEntityOnlyPkList
, Char ( 13 ) + Char ( 10 )
, olist.PumlObjectRefList
, Char ( 13 ) + Char ( 10 ) + puml_footer.Parameter_value_result + Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
)
From
docs.Culture As c
Left Join
docs.ObjectRefCyclic_EntityList As elist
On
elist.cultures_name = c.cultures_name
Cross Join docs.ObjectRefCyclic_ObjectRefList As olist
Cross Join config.ftv_get_parameter_value ( 'puml_footer', 'interactive' ) As puml_footer