汇科天下
Page tree

Versions Compared

Old Version 7

changes.mady.by.user 张扬

Saved on

compared with

New Version Current

changes.mady.by.user 张扬

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip
  • 版本（SINK_NODE_ENTITY = 'Version'）
  • 问题类型页面方案（SINK_NODE_ENTITY=‘IssueTypeScreenScheme’）
  • 通知方案（SINK_NODE_ENTITY =‘NotificationScheme’）
  • 权限方案（SINK_NODE_ENTITY =‘PermissionScheme’）
  • 工作流方案（SINK_NODE_ENTITY =‘WorkflowScheme’）
  • 安全级别方案（SINK_NODE_ENTITY =‘IssueSecurityScheme’）
Code Block
linenumberstrue
collapsetrue
SELECT
	na.SOURCE_NODE_ID as "问题id",
	na.SINK_NODE_ID as "模块id",
	c.cname as "模块名称"
FROM
	nodeassociation na
	LEFT JOIN component c on na.SINK_NODE_ID=c.ID
WHERE
	SOURCE_NODE_ID = 10939 
	AND SINK_NODE_ENTITY = 'Component';

...