报表查询和属性权限设置问题

by zhengyj 2014.1.24 11:55

注:脚本执行有风险,对于客户正式环境请在研发指导下执行。

支持问题: 9201401220088

问题原因:经过和kxl联合调试,发现问题是由于选择的供应商编码这个栏目,设置的属性权限不允许读取,导致把这个栏目给去掉了。而供应商排名分析报表当选择考核依据时,必须要这个供应商编码,导致此问题。
解决方案:在设置 属性权限里,设置供应商编码 允许 读取

查询sql:

 select
  attri.Name,attri.GroupName
  ,entitybe.FullName,entitybe.*
  from ubf_md_attribute as attri
  inner join UBF_MD_Class as entitybe on attri.MD_Class_ID = entitybe.ID
  where attri.ID = '8059f987-c6e8-4767-b101-ca2100e87c06'
  
  
  select  A1.[Code] as [fullname], A.[Code], A2.[Name], A.[EValue], A1.[UID] as [U2ID], A3.[Name] as [TypeName], A.[IsSystem] from  UBF_Sys_ExtEnumValue as A  left join [UBF_Sys_ExtEnumType] as A1 on (A.[ExtEnumType] = A1.[ID])  left join [UBF_Sys_ExtEnumValue_Trl] as A2 on (A2.SysMlFlag = 'zh-CN') and (A.[ID] = A2.[ID])  left join [UBF_Sys_ExtEnumType_Trl] as A3 on (A3.SysMlFlag = 'zh-CN') and (A1.[ID] = A3.[ID]) where  A1.[UID] in ('b5a2ca41-671a-4fe9-a1af-88de5c8d73d3', 'debbc308-9509-4374-8bf9-c182ece35d71', '63382658-4a66-4aad-929e-ee3b013d7397', '63382658-4a66-4aad-929e-ee3b013d7397', 'e5edf384-7410-417a-bcd2-8c4951185535', '28442b75-3e0d-4552-93fb-b1ea3abc7b0a', 'ede29d25-8082-4471-afe9-af06cdec9f46', '73562e6a-23d3-4110-9d0f-00a4ab411435')
 
 
 select * from Base_User where ID = 1001302200001757
 
 select  A.[AuthorityItem],A.* from  UBF_Security_AuthorityCredential as A
 where  (((((A.[Org] = 1001301194798186) and (A.[User] = 1001302200001757))
 and (A.[AuthorityItemType] = 256))
 and A.[AuthorityItem] in (1001101157662625,
  1001101151281013,
  1001101157663857,
  1001101157663856))
  --and (A.[Opinion] = 0)
  )
 
 select * from  UBF_Security_AuthorityItem  where ID = 1001101157663856
 
select a.AuthorityItem, d.MapObject 
from UBF_Security_AuthorityCredential a 
inner join UBF_Security_AuthorityItem d on a.AuthorityItem =d.ID 
where a.AuthorityItemType = '258'
and a.Org = '1001301194798186' and a.[User] = '1001302200001757' and  a.Opinion = 0

 

Tags:

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
653483 条评论
11 次评分
233685 次访问
访问统计开始于 2019年12月15日
平均日访问 5434 次
当前 84 人在线