workflow.Biml_PrecedenceConstraints - V
type: V ( view ), modify_date: 2022-09-08 16:18:05
RepoObject_guid: A4BCD983-91FA-EB11-850E-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_Biml_PrecedenceConstraints__1
-
IndexSemanticGroup: no_group
-
[column-Workflow_id]; int
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_Biml_PrecedenceConstraints__2
-
IndexSemanticGroup: no_group
-
[column-Workflow_id]; int
-
-
PK, Unique, Real: 0, 0, 0
idx_Biml_PrecedenceConstraints__3
-
IndexSemanticGroup: no_group
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
workflow.Biml_PrecedenceConstraints - V script
CREATE View workflow.Biml_PrecedenceConstraints
As
Select
Workflow_id
, referencing_Procedure_RepoObject_guid
, referencing_TaskName = Max ( referencing_TaskName )
, PrecedenceConstraints =
--
' <PrecedenceConstraints>' + Char ( 13 ) + Char ( 10 ) + ' <Inputs>' + Char ( 13 ) + Char ( 10 )
+ String_Agg (
Cast(' <Input OutputPathName="' As NVarchar(Max)) + referenced_TaskName + '.Output" />'
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
referenced_TaskName) + Char ( 13 ) + Char ( 10 ) + ' </Inputs>' + Char ( 13 )
+ Char ( 10 ) + ' </PrecedenceConstraints>' + Char ( 13 ) + Char ( 10 )
From
workflow.Workflow_ProcedureDependency_T_TaskName
Group By
Workflow_id
, referencing_Procedure_RepoObject_guid