在Dynamics CRM中是否可以运行SQL查询（如高级查找和包含选择框）？ [英] Is it possible in Dynamics CRM to run an SQL query like an advanced find and include selection boxes?

问题描述

在Dynamics CRM-2011中，高级查找的结果以记录网格的形式显示，每个记录都有一个复选框，用于选择记录以采取进一步的适当操作。是否可以使用基于SQL的查询来获得类似的结果？

In Dynamics CRM-2011 the results of an advanced find are presented as a grid of records, each with a checkbox to select the record for further appropriate actions. Is it possible to use an SQL-based query to achieve a similar result?

我已经将数据质量方案实现为业务规则实体，每个规则都包含SQL查询的文本，用于报告失败特定规则的记录。有一个例外报告可以针对任何选定的规则运行，并返回失败记录的列表，该记录可以是任何类型（取决于规则）。如果不是作为报表运行，而是作为查询运行并显示带有复选框的失败记录以选择要执行的操作，那就太好了。

I have implemented a data quality scheme as a business-rules entity, each rule containing the text of an SQL query for reporting records that fail the particular rule. There is an exceptions report that can run for any selected rule(s) and returns the list of failed records, which can be of any type (rule dependent). It would be great if instead of running as a report, it ran as a query and displayed the failed records with checkboxes to select them for action.

如果有人有任何想法如何实现这一目标，我将不胜感激任何指针。

If anyone has any idea how this might be achieved, I would be grateful for any pointers.

Simon。

推荐答案

我相信您唯一的选择是自定义Web应用程序。您可以选择一个业务规则，让应用程序检索所有失败的实体，然后将它们显示在标准网格中，您可以从中选择并对它们执行操作。此应用程序可以使用CRM样式，并可以在CRM中启动以使其与内置功能无缝连接。

I believe that your only option is a custom web application. You could select a business rule, have the application retrieve all entities that fail the rule, and display them in a standard grid from which you can select and perform actions on them. This application could use CRM styles and be launched within CRM to make it seamless with built in functionality.

这篇关于在Dynamics CRM中是否可以运行SQL查询（如高级查找和包含选择框）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！