Dynamics CRM 365 查询实体之间的关系---SQL篇
2022/8/3 2:23:00
本文主要是介绍Dynamics CRM 365 查询实体之间的关系---SQL篇,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
crmsql语句查询实体窗体实体字段关系信息
![](/upload/202208/03/202208030222595946.png)
在crm里面如何用sql语句查询这些信息?
查询实体信息:
--查询实体信息,实体名称:account
select * from MetadataSchema.Entity where name= 'account'
查询窗体信息:
--查询窗体信息,ObjectTypeCode: 实体的code
select * from systemform where ObjectTypeCode = 1
查询视图信息:
--查询视图信息,ReturnedTypeCode:实体的code
select * from SavedQuerybase where ReturnedTypeCode = 1
查询字段信息:
--查询字段信息
with attr as(
select * from MetadataSchema.Attribute as a
where a.EntityId in (select entityid from MetadataSchema.Entity
where name = 'new_member') and a.IsCustomField = 1
)
select a.attributeid,a.Name,label.Label,ty.Description,
(select top 1 name from MetadataSchema.Entity where EntityId in (
select ship.ReferencedEntityId from MetadataSchema.Relationship as ship
where ship.ReferencingAttributeId = a.AttributeId)) as 'lookName'
from attr as a inner join MetadataSchema.LocalizedLabel as label
on a.attributeid = label.objectid inner join MetadataSchema.AttributeTypes as ty
on a.AttributeTypeId = ty.AttributeTypeId
where label.objectcolumnname = 'DisplayName' and a.validforcreateapi = 1
查询关系信息:
select * from MetadataSchema.Relationship where ReferencingEntityId in
(select top 1 entityid from MetadataSchema.Entity where name = 'new_store')
原文链接:https://blog.csdn.net/y_f123/article/details/37955601
这篇关于Dynamics CRM 365 查询实体之间的关系---SQL篇的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-29易优CMS安装常见问题汇总-icode9专业技术文章分享
- 2024-06-28易优新手必读安装教程-icode9专业技术文章分享
- 2024-06-28忘记eyoucms后台密码怎么办?-icode9专业技术文章分享
- 2024-06-26终极指南:Scrum中如何设置需求优先级
- 2024-06-26AI大模型企业应用实战(25)-为Langchain Agent添加记忆功能
- 2024-06-26小白家庭 nas 搭建方案-icode9专业技术文章分享
- 2024-06-23AI大模型企业应用实战(14)-langchain的Embedding
- 2024-06-23AI大模型企业应用实战(15)-langchain核心组件
- 2024-06-23AI大模型企业应用实战(16)-langchain核心组件
- 2024-06-23AI 大模型企业应用实战(06)-初识LangChain