显示带有筛选在crm 365中查找的两个或三个字段的子网格 [英] show the sub grid with filtering two or three fields that all are look up in crm 365

问题描述

我有两个自定义实体。

我想显示子网格并过滤两个或三个要查找的字段。
我想以SQL方式

I want to show the sub grid with filtering two or three fields that all are look up. In SQL way I want to

 select * from table where field 1 = *** or field 2=*** or filed 3 =*** 

但是在CRM中，您只能选择一个字段。
我不知道如何添加xml，我也不知道，我应该在加载表单时创建js还是导出解决方案，将过滤器添加到fetchxml中，然后将其导入到crm？

But in CRM it's not possible you can select only one field. I dont know how to add fetch xml and also i dont know, Should I create js on load of form or export solution add filter to fetchxml then import it to crm?

推荐答案

您是否尝试过创建自定义视图，可以在其中设置此过滤条件并在Subgrid上使用此视图

Have you tried creating a Custom View where you can set up this filter criteria and use this view on the Subgrid

这里有详细信息： https://crmbook.powerobjects.com/ system-administration / customization / customizing-views /

这篇关于显示带有筛选在crm 365中查找的两个或三个字段的子网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！