workflow.WorkflowStep_active - V

type: V ( view ), modify_date: 2022-06-14 11:06:05

RepoObject_guid: 4CB8C8A5-CEF9-EB11-850D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-workflow.workflowstep_active

Columns

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

bit

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NOT NULL

int

NOT NULL

nvarchar(500)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-workflow.workflowstep_active

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.workflowstep_active

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.workflowstep_active

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.workflowstep_active

Column Reference Diagram

entity_1_1_colref-workflow.workflowstep_active

Indexes

idx_WorkflowStep_active__1

idx_WorkflowStep_active__2

idx_WorkflowStep_active__3

Column Details

_

is_PossibleReferenced

is_PossibleReferenced

bit

NOT NULL

Procedure_RepoObject_guid

Procedure_RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

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


Workflow_id

Workflow_id

int

NOT NULL

Referencing Columns

Workflow_Name

Workflow_Name

nvarchar(500)

NOT NULL

Referenced Columns
Referencing Columns

sql_modules_definition

workflow.WorkflowStep_active - V script
/*active workflows and active steps*/
CREATE View workflow.WorkflowStep_active
As
Select
    T1.Workflow_id
  , Workflow_Name = T2.Name
  , T1.Procedure_RepoObject_guid
  , T1.is_PossibleReferenced
  , ro.RepoObject_fullname
From
    workflow.WorkflowStep As T1
    Inner Join
        workflow.Workflow As T2
            On
            T1.Workflow_id               = T2.id

    Inner Join
        repo.RepoObject   As ro
            On
            T1.Procedure_RepoObject_guid = ro.RepoObject_guid
Where
    ( T1.is_active     = 1 )
    And ( T2.is_active = 1 )