workflow.Biml_Task - V

type: V ( view ), modify_date: 2021-08-17 20:24:20

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

Description

Examples

Entity Diagram

entity-workflow.biml_task

Columns

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

uniqueidentifier

NOT NULL

nvarchar(257)

NOT NULL

nvarchar(max)

NOT NULL

nvarchar(4000)

NULL

int

NOT NULL

nvarchar(500)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.biml_task

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.biml_task

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.biml_task

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.biml_task

Column Reference Diagram

entity_1_1_colref-workflow.biml_task

Indexes

idx_Biml_Task__1

idx_Biml_Task__2

idx_Biml_Task__3

Column Details

_

Procedure_RepoObject_guid

Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


TaskBiml

TaskBiml

nvarchar(max)

NOT NULL

TaskName

TaskName

nvarchar(4000)

NULL

Workflow_id

Workflow_id

int

NOT NULL

Workflow_Name

Workflow_Name

nvarchar(500)

NOT NULL

sql_modules_definition

workflow.Biml_Task - V script
CREATE View workflow.Biml_Task
As
Select
    T1.Workflow_id
  , T1.Workflow_Name
  , T1.Procedure_RepoObject_guid
  , ro1.RepoObject_fullname2
  , TaskName = Replace ( ro1.RepoObject_fullname2, '.', '_' )
  , TaskBiml =
  /*
                  <ExecuteSQL Name="usp_PERSIST_ModellRessource_T" ConnectionName="target">
                    <PrecedenceConstraints>
                        <Inputs>
                            <Input OutputPathName="mod_ModellRessource.Output" />
                        </Inputs>
                    </PrecedenceConstraints>
                    <DirectInput>EXEC [modT].[usp_PERSIST_ModellRessource_T]
					</DirectInput>
                </ExecuteSQL>
*/
  Concat ( --
             Cast('  <ExecuteSQL Name="' As NVarchar(Max))
           , Replace ( ro1.RepoObject_fullname2, '.', '_' )
           , '" ConnectionName="target">'
           , Char ( 13 ) + Char ( 10 )
           , pc.PrecedenceConstraints
           , '    <DirectInput>EXEC '
           , ro1.RepoObject_fullname
           , Char ( 13 ) + Char ( 10 )
           , '    </DirectInput>'
           , Char ( 13 ) + Char ( 10 )
           , '  </ExecuteSQL>'
         )
From
    workflow.WorkflowStep_active            As T1
    Inner Join
        repo.RepoObject                     As ro1
            On
            T1.Procedure_RepoObject_guid                 = ro1.RepoObject_guid

    Left Join
        workflow.Biml_PrecedenceConstraints As pc
            On
            pc.Workflow_id                               = T1.Workflow_id
            And pc.referencing_Procedure_RepoObject_guid = T1.Procedure_RepoObject_guid