积极答复者
登录用户的查询权限

问题
答案
-
你可以通过CRMService来返回A部门经理所能查看的客户信息,也可以用SQL连接FilteredView来实现查询。
Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn- 已标记为答案 Batistuta CaiModerator 2009年8月7日 1:12
全部回复
-
跟踪到了一段是返回登录用户可查看的客户集合,但是使用CRM WEBSERVICE不知道咋写。
select top 51 account0.Name as name, account0.PrimaryContactId as primarycontactid, account0.Telephone1 as
telephone1, account0.new_shi_zhou as new_shi_zhou, account0.OwnerId as ownerid, account0.AccountId as accountid,
account0.PrimaryContactIdName as primarycontactidname, account0.PrimaryContactIdYomiName as primarycontactidyominame,
account0.PrimaryContactIdDsc as primarycontactiddsc, account0.new_shi_zhouName as new_shi_zhouname, account0.new_shi_zhouDsc as
new_shi_zhoudsc, account0.OwnerIdDsc as owneriddsc, account0.OwnerIdYomiName as owneridyominame, account0.OwnerIdType as
owneridtype, account0.OwnerIdName as owneridname, accountprimarycontactidcontactcontactid.EMailAddress1 as
emailaddress1 from Account as account0 left outer join Contact as
accountprimarycontactidcontactcontactid on (account0.PrimaryContactId = accountprimarycontactidcontactcontactid.ContactId and
((accountprimarycontactidcontactcontactid.DeletionStateCode in (0))
and (accountprimarycontactidcontactcontactid.OwningUser = '771ae8fc-d169-de11-99ac-00241d150e1a' or accountprimarycontactidcontactcontactid.ContactId in
(select POA.ObjectId from PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId where sup.SystemUserId =
'771ae8fc-d169-de11-99ac-00241d150e1a' and POA.ObjectTypeCode = 2 and ((POA.AccessRightsMask|POA.InheritedAccessRightsMask) & 1) = 1))))
where (account0.StateCode = 0 and (account0.DeletionStateCode in (0)) and (account0.OwningUser =
'771ae8fc-d169-de11-99ac-00241d150e1a' or account0.OwningBusinessUnit = 'C4C70E5A-F06C-DE11-99A6-00241D150E1A' or account0.AccountId in (select POA.ObjectId from
PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId where sup.SystemUserId =
'771ae8fc-d169-de11-99ac-00241d150e1a' and POA.ObjectTypeCode = 1 and ((POA.AccessRightsMask|POA.InheritedAccessRightsMask)
& 1) = 1))) order by account0.Name asc, account0.AccountId asc -
你可以通过CRMService来返回A部门经理所能查看的客户信息,也可以用SQL连接FilteredView来实现查询。
Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn- 已标记为答案 Batistuta CaiModerator 2009年8月7日 1:12