在3.0时ms针对这个问题发布了两个补丁(都没有中文版 ) 934805和 924879,update到4.0后补丁也不起作用了.
虽然补丁失效,但是4.0可以通过Plugin来解决,在Pre RetrieveMultiple Message Plugin中修改查询条件,使查询返回所有相关记录(包括active和inactive).
plugin代码如下:
using
System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
namespace SamplePlugins
{
public class PreRetrieveMultiple : IPlugin
{
IPlugin Members#region IPlugin Members
public void Execute(IPluginExecutionContext context)
{
if (context.InputParameters.Contains(ParameterName.Query))
{
QueryExpression qe = context.InputParameters[ParameterName.Query] as QueryExpression;
if (qe.EntityName == context.PrimaryEntityName && qe.Criteria != null && qe.Criteria.Conditions != null && qe.Criteria.Conditions.Count == 2)
{
ConditionExpression ce = qe.Criteria.Conditions[0] as ConditionExpression;
if (ce != null && ce.AttributeName == "statecode" && ce.Operator == ConditionOperator.Equal && ((int)ce.Values[0]) == 0)
{
qe.Criteria.Conditions.Remove(ce);
}
}
}
}
#endregion
}
}
plugin注册信息如下图:
using System.Collections.Generic;
using System.Text;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
namespace SamplePlugins
{
public class PreRetrieveMultiple : IPlugin
{
IPlugin Members#region IPlugin Members
public void Execute(IPluginExecutionContext context)
{
if (context.InputParameters.Contains(ParameterName.Query))
{
QueryExpression qe = context.InputParameters[ParameterName.Query] as QueryExpression;
if (qe.EntityName == context.PrimaryEntityName && qe.Criteria != null && qe.Criteria.Conditions != null && qe.Criteria.Conditions.Count == 2)
{
ConditionExpression ce = qe.Criteria.Conditions[0] as ConditionExpression;
if (ce != null && ce.AttributeName == "statecode" && ce.Operator == ConditionOperator.Equal && ((int)ce.Values[0]) == 0)
{
qe.Criteria.Conditions.Remove(ce);
}
}
}
}
#endregion
}
}
注册成功后再开定单查看关联视图是否已经显示停用记录,如下图