阅读:2718
回复:2
|
[已解决]流程类别存哪个表?![]() |
1楼#
发布于:2016-08-29 10:19
搞定了
SELECT A.WorkflowCode, A.DefaultVersion, A.DisplayName,D.DisplayName FROM OT_WorkflowClause A JOIN OT_FunctionNode C ON A.WorkflowCode=C.Code and C.NodeType=30 JOIN OT_FunctionNode D on C.ParentCode=D.Code and D.NodeType=20 and (D.ParentPropertyName is null or D.ParentPropertyName='Y') WHERE A.State>0 ORDER BY A.SortKey ASC, A.WorkflowCode |
|
2楼#
发布于:2016-08-30 13:58
![]() |
|
|