workflow.WorkflowStep_src - V
type: V ( view ), modify_date: 2021-12-16 11:41:19
RepoObject_guid: 4DB8C8A5-CEF9-EB11-850D-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
2 |
|
|
Indexes
PK_WorkflowStep_src
-
IndexSemanticGroup: no_group
-
[column-Workflow_id]; int
-
[column-Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
Column Details
sql_modules_definition
workflow.WorkflowStep_src - V script
/*potential workflow steps, based on all usp_persistence_RepoObject_guid*/
CREATE View workflow.WorkflowStep_src
As
Select
Distinct
Workflow_id = T1.id
, Procedure_RepoObject_guid = T2.usp_persistence_RepoObject_guid
From
workflow.Workflow As T1
, repo.RepoObject_gross As T2
Where
T1.is_active = 1
And Not T2.usp_persistence_RepoObject_guid Is Null