CRM 实体列名和标签名称
2024-08-22 14:58:13
CREATE VIEW v_entity_attribute AS SELECT EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName, AttributeView.Name AS AttributeName, LocalizedLabelView_2.Label AS AttributeDisplayName FROM LocalizedLabelView AS LocalizedLabelView_2 INNER JOIN AttributeView ON LocalizedLabelView_2.ObjectId = AttributeView.AttributeId RIGHT OUTER JOIN EntityView INNER JOIN LocalizedLabelView AS LocalizedLabelView_1 ON EntityView.EntityId = LocalizedLabelView_1.ObjectId ON AttributeView.EntityId = EntityView.EntityId WHERE LocalizedLabelView_1.ObjectColumnName = 'LocalizedName' AND LocalizedLabelView_2.ObjectColumnName = 'DisplayName' AND LocalizedLabelView_1.LanguageId = '' AND LocalizedLabelView_2.LanguageId = ''
最新文章
- Host is not allowed to connect to this MySQL server 错误的处理方法
- DATEADD和DATEDIFF函数、其他日期处理方法 、已打开的端口、FORMAT函数
- Android Launcher 研究学习
- vector 初始化所有方法
- jQuery Mobile 页面事件总结
- 怎样利用App打造自明星实现自盈利
- WindowsPhone8SDK重装后设计器加载异常的处理办法
- Java-Preferences用法-入门
- notepad的快捷操作-代码速写
- MacOS 下安装mysqlclient 的问题及解决办法
- Linux 常见目录与区别
- U盘安装CentOS 7问题解决
- RS232串口的Windows编程纪要
- 部署JupyterLab和pyalgotrade搭建web策略回测环境
- Caused by: java.lang.NumberFormatException: For input string: ";18446744073709551615";
- TF之AE:AE实现TF自带数据集数字真实值对比AE先encoder后decoder预测数字的精确对比—Jason niu
- linux svn 多项目设置
- 【应用安全】S-SDLC安全开发生命周期
- javascript,移动划过超链接鼠标变手型
- 如何将service绑入到spring 并且在action中使用