CRM 2011中的CRMAF筛选 [英] CRMAF Filtering in CRM 2011

问题描述

我正在尝试在CRM 2011的报告中使用CRM CRMAF过滤器。但是我找不到任何有关此操作的示例。需要更改查询内容以过滤引号，以及需要添加什么参数。

I am trying to use CRM CRMAF Filter in a report for CRM 2011. But I can't find any examples on how to do it. What does the query need to be changed to to filter on Quotes and what Parameter needs to be added.

SELECT           Quote.QuoteNumber, Quote.Name, Quote.CreatedOn, Quote.CustomerIdName, Quote.OwnerIdName, SystemUser.Address1_Telephone1, 
                         SystemUser.InternalEMailAddress, Quote.Name AS Expr1, Quote.BillTo_Line1, Quote.BillTo_Line2, Quote.BillTo_Line3, Quote.BillTo_StateOrProvince, 
                         Quote.BillTo_PostalCode, Quote.BillTo_Telephone, Quote.BillTo_Fax, QuoteDetail.LineItemNumber, QuoteDetail.Quantity, QuoteDetail.ProductId, 
                         QuoteDetail.ProductDescription, QuoteDetail.BaseAmount, QuoteDetail.ExtendedAmount, Quote.DiscountAmount, Quote.TotalTax, Quote.TotalAmount, 
                         Quote.RevisionNumber
FROM            Quote INNER JOIN
                         QuoteDetail ON Quote.QuoteId = QuoteDetail.QuoteId INNER JOIN
                         SystemUser ON Quote.OwnerId = SystemUser.SystemUserId

推荐答案

您可以查看以下参考：
http://blogs.msdn.com/b/crm/archive/2009/03/06/microsoft-dynamics-crm-pre-filtering-tips.aspx

Here is one reference you can take a look at: http://blogs.msdn.com/b/crm/archive/2009/03/06/microsoft-dynamics-crm-pre-filtering-tips.aspx

您最终将使用CRM为每个实体创建的特殊筛选视图。

You end up using the special filtered views that CRM creates for each entity.

SELECT name, accountnumber 
FROM FilteredAccount as CRMAF_Account

另一个参考：
http://msdn.microsoft.com/en-us/library/gg309722

这篇关于CRM 2011中的CRMAF筛选的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！