workflow.Biml_PrecedenceConstraints - V

type: V ( view ), modify_date: 2022-09-08 16:18:05

RepoObject_guid: A4BCD983-91FA-EB11-850E-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.biml_precedenceconstraints

Columns

Table 1. Columns of workflow.Biml_PrecedenceConstraints - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

nvarchar(4000)

NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.biml_precedenceconstraints

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.biml_precedenceconstraints

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.biml_precedenceconstraints

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.biml_precedenceconstraints

Column Reference Diagram

entity_1_1_colref-workflow.biml_precedenceconstraints

Indexes

idx_Biml_PrecedenceConstraints__1

idx_Biml_PrecedenceConstraints__2

idx_Biml_PrecedenceConstraints__3

Column Details

_

PrecedenceConstraints

PrecedenceConstraints

nvarchar(max)

NULL

referencing_Procedure_RepoObject_guid

referencing_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_TaskName

referencing_TaskName

nvarchar(4000)

NULL

Workflow_id

Workflow_id

int

NOT NULL

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