workflow.Workflow_ProcedureDependency_T_NotInSortorder_check - V

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

RepoObject_guid: BA0BC0EB-B301-EC11-8510-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.workflow_proceduredependency_t_notinsortorder_check

Columns

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

uniqueidentifier

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NOT NULL

nvarchar(261)

NOT NULL

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.workflow_proceduredependency_t_notinsortorder_check

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.workflow_proceduredependency_t_notinsortorder_check

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.workflow_proceduredependency_t_notinsortorder_check

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.workflow_proceduredependency_t_notinsortorder_check

Column Reference Diagram

entity_1_1_colref-workflow.workflow_proceduredependency_t_notinsortorder_check

Indexes

idx_Workflow_ProcedureDependency_T_NotInSortorder_check__1

idx_Workflow_ProcedureDependency_T_NotInSortorder_check__2

idx_Workflow_ProcedureDependency_T_NotInSortorder_check__3

idx_Workflow_ProcedureDependency_T_NotInSortorder_check__4

idx_Workflow_ProcedureDependency_T_NotInSortorder_check__5

Column Details

_

referenced_Procedure_RepoObject_guid

referenced_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

referencing_Procedure_RepoObject_guid

referencing_Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_fullname_1

RepoObject_fullname_1

nvarchar(261)

NOT NULL

Description

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


RepoObject_fullname_2

RepoObject_fullname_2

nvarchar(261)

NOT NULL

Description

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


Workflow_id

Workflow_id

int

NOT NULL

sql_modules_definition

workflow.Workflow_ProcedureDependency_T_NotInSortorder_check - V script
/*
This view must be empty after calling [workflow].[usp_workflow], +
because all entries from workflow.Workflow_ProcedureDependency_T_NotInSortorder must be transferred to workflow.WorkflowStep_Sortorder.

If there are still entries here, then

* the content of [workflow].[Workflow_ProcedureDependency_T_bidirectional] must be checked.
* Entries in [workflow].[WorkflowStep] should then be marked with [is_PossibleReferenced] = 1.

*/
CREATE View workflow.Workflow_ProcedureDependency_T_NotInSortorder_check
As
Select
    T1.Workflow_id
  , T1.referenced_Procedure_RepoObject_guid
  , T1.referencing_Procedure_RepoObject_guid
  , RepoObject_fullname_1 = ro1.RepoObject_fullname
  , RepoObject_fullname_2 = ro2.RepoObject_fullname
From
    workflow.Workflow_ProcedureDependency_T_NotInSortorder As T1
    Inner Join
        repo.RepoObject                                    As ro1
            On
            T1.referenced_Procedure_RepoObject_guid  = ro1.RepoObject_guid

    Inner Join
        repo.RepoObject                                    As ro2
            On
            T1.referencing_Procedure_RepoObject_guid = ro2.RepoObject_guid
--Order By
--    T1.Workflow_id
--  , ro2.RepoObject_fullname
--  , ro1.RepoObject_fullname;