Dynamics CRM SQL 实体ObjectTypeCode查询&表单共享用户的查询

1.实体ObjectTypeCode查询 SELECT [ObjectTypeCode] FROM Entity WITH(NOLOCK) WHERE nameEntityName 2.表单共享用户的查询   --PrinciplId

1.实体ObjectTypeCode查询

SELECT [ObjectTypeCode] FROM Entity WITH(NOLOCK) WHERE name='EntityName'

2.表单共享用户的查询  

--PrinciplId是SystemUserId
SELECT PrincipalId,PrincipalTypeCode,AccessRightsMask
FROM PrincipalObjectAccess  WITH(NOLOCK) 
WHERE  
OBJECTTypeCode= (SELECT [ObjectTypeCode] FROM Entity WITH(NOLOCK) WHERE name='EntityName')
AND ObjectId='EntityRecordId'

 

发布者:admin,转转请注明出处:http://www.yc00.com/web/1740274733a4220313.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信