c# - CRM Online RetrieveMultiple 与 OptionSetValueCollection 条件

Question

我正在尝试从多选项集选择列表中检索包含某些选项集值的记录。

这一行使我的代码失败:

int[] values = GetValues();
query.Criteria.AddCondition(new ConditionExpression(fieldName, 
ConditionOperator.ContainValues, values);

当我用逗号分隔符放置值时，代码有效:

query.Criteria.AddCondition(new ConditionExpression(fieldName, 
ConditionOperator.ContainValues, 1,2,3);

唯一的问题是这些值是动态的，所以我不能那样做。到目前为止，我发现克服它的唯一方法是:

FilterExpression filter = new FilterExpression(LogicalOperator.Or);
foreach (int value in values)
{
    filter.AddCondition(new ConditionExpression(fieldName, 
        ConditionOperator.ContainValues, value));
}
query.Criteria.AddFilter(filter);

只是想知道是否有比这个更好的解决方案？

Answer 1

您可以尝试使用 In。

Query data from multi-select picklists

With the Web API there are the equivilent ContainValues and DoesNotContainValues query functions.

Other existing condition operators that can be used with this type of attribute include: Equal, NotEqual, NotNull, Null, In and NotIn.