EAS权限查询

最新推荐文章于 2022-07-14 17:33:07 发布

fenyu8

最新推荐文章于 2022-07-14 17:33:07 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： EAS　BOS

本文链接：https://blog.youkuaiyun.com/fenyu8/article/details/25608821

EAS　BOS 专栏收录该内容

128 篇文章

订阅专栏

本文介绍了一种SQL查询方法，用于从多个表中联接并筛选特定的内部账户明细相关权限项，按所有者编号、组织编号及权限项长编号进行排序。

SELECT 

DISTINCT "USERORGPERM".FID AS "ID", 
"PERMITEM".FNumber AS "PERMITEM.NUMBER", 
"PERMITEM".FName AS "PERMITEM.NAME", 
"OWNER".FNumber AS "OWNER.NUMBER", 
"OWNER".FName_l2 AS "OWNER.NAME", 
"DEFORGUNIT".FDisplayName_l2 AS "DEFORGUNIT.DISPLAYNAME", 
"ORG".FDisplayName_l2 AS "ORG.DISPLAYNAME", 
"ORG".FNumber AS "ORG.NUMBER", 
"CTRLUNIT".FLongNumber AS "CTRLUNIT.LONGNUMBER", 
"CTRLUNIT".FDisplayName_l2 AS "CTRLUNIT.DISPLAYNAME", 
"CTRLUNIT".FName_l2 AS "CTRLUNIT.NAME", 
"CTRLUNIT".FNumber AS "CTRLUNIT.NUMBER", 
"CTRLUNIT".FID AS "CTRLUNIT.ID", 
"PERMITEM".FAlias_l2 AS "PERMITEM.ALIAS", 
"PERMITEM".FID AS "PERMITEM.ID", 
"OWNER".FID AS "OWNER.ID", 
"ORG".FID AS "ORG.ID", 
"PERMITEM".FLongNumber AS "PERMITEM.LONGNUMBER"

FROM T_PM_UserOrgPerm AS "USERORGPERM"

INNER JOIN T_PM_PermItem AS "PERMITEM"
ON "USERORGPERM".FPermItemID = "PERMITEM".FID

INNER JOIN T_PM_User AS "OWNER"
ON "USERORGPERM".FOwner = "OWNER".FID

INNER JOIN T_ORG_BaseUnit AS "ORG"
ON "USERORGPERM".FOrgID = "ORG".FID

INNER JOIN T_ORG_CtrlUnit AS "CTRLUNIT"
ON "USERORGPERM".FCtrlUnitID = "CTRLUNIT".FID

INNER JOIN T_ORG_BaseUnit AS "DEFORGUNIT"
ON "OWNER".FDefOrgUnitID = "DEFORGUNIT".FID

where "PERMITEM".FAlias_l2 like '%内部账户明细%'

ORDER BY 
"OWNER.NUMBER" ASC,
"ORG.NUMBER" ASC,
"PERMITEM.LONGNUMBER" ASC