logs.ExecutionLog_puml_Sequence_start_stop - V
type: V ( view ), modify_date: 2022-06-30 19:08:33
RepoObject_guid: BF90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
parent_proc_fullname
parent_proc_fullname |
|
|
Description
(concat(quotename([proc_schema_name]),'.',quotename([proc_name])))
Referenced Columns
sql_modules_definition
logs.ExecutionLog_puml_Sequence_start_stop - V script
CREATE View [logs].[ExecutionLog_puml_Sequence_start_stop]
As
Select
T1.id
, T1.execution_instance_guid
, puml_Sequence_start_stop =
--
Concat ( Case
When parent.parent_proc_fullname <> ''
Then
Concat ( '"', parent.parent_proc_fullname, '"' )
--ELSE CONCAT('"' , [T1].[execution_instance_guid] , '"')
End
, Case T1.step_name
When 'start'
Then
' -> '
When 'end'
Then
' <- '
End
, '"'
, concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
, '"'
, Char ( 13 ) + Char ( 10 )
, Case T1.step_name
When 'start'
Then
'activate '
When 'end'
Then
'deactivate '
End
, '"'
, concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
, '"'
)
, proc_fullname = Concat(quotename(T1.[proc_schema_name]),'.',quotename(T1.[proc_name])) -- T1.proc_fullname
, parent.parent_proc_fullname
, T1.created_dt
From
logs.ExecutionLog As T1
Left Join
logs.ExecutionLog_parent As parent
On
parent.id = T1.id
Where
T1.step_name In
( 'start', 'end' )
sql