docs.ssis_PumlPartialTaskComponent - V
type: V ( view ), modify_date: 2021-11-22 19:49:05
RepoObject_guid: ABDCAD7F-F73E-EC11-852D-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
TaskPathLevel
TaskPathLevel |
|
|
Description
(len([TaskPath])-len(replace([TaskPath],'\','')))
Referenced Columns
sql_modules_definition
docs.ssis_PumlPartialTaskComponent - V script
CREATE View [docs].[ssis_PumlPartialTaskComponent]
As
Select
T3.AntoraModule
, T3.PackageName
, T3.TaskPath
, T3.TaskName
, T3.TaskPathLevel
, T3.TaskPathLevelLag
, T3.TaskPathLevelLead
, T3.TaskPathParent
, PumlPartialTaskComponent =
--former task was a sub task and now we are back on a higher level, we nee '}' to close the previous block
Iif(T3.TaskPathLevel < T3.TaskPathLevelLag
, Replicate ( ' ', T3.TaskPathLevel ) + '}' + Char ( 13 ) + Char ( 10 )
, '')
--
+
--
Replicate ( ' ', T3.TaskPathLevel ) + 'component "' + T3.TaskName + '" as '
+ docs.fs_cleanStringForAnchorId ( T3.TaskPath )
--
+ ' <<' + T3.TaskType + '>> '
--
--hyperlink:
--+ ' [[#task-' + docs.fs_cleanStringForAnchorId ( T3.TaskPath ) + ']]'
--+ ' [[puml-link:' + docs.fs_cleanStringForFilename ( T3.PackageBasename ) + '.adoc#task-'
--+ docs.fs_cleanStringForAnchorId ( T3.TaskPath ) + ']]'
+ ' [[../' + docs.fs_cleanStringForFilename ( T3.PackageBasename ) + '.html#task-'
+ docs.fs_cleanStringForAnchorId ( T3.TaskPath ) + ']]'
--
--current Task has sub tasks = the level of the next task is higher = the next task is a sub task
+ Iif(T3.TaskPathLevelLead > T3.TaskPathLevel, ' {', '')
From
ssis.PackageTask_LevelLagLead As T3sql