ConditionOperator枚举

ConditionOperator枚举

命名空间: Microsoft.Xrm.Sdk.Query
程序集: Microsoft.Xrm.Sdk（在 Microsoft.Xrm.Sdk.dll 中）

官方文档

点我即可跳转

常用

//1.equal，optionset == 100000000
QueryExpression queryExpression = new QueryExpression("stz_workhoursdetail");
queryExpression.ColumnSet = new ColumnSet(true);
queryExpression.Criteria.AddCondition("stz_multipleordersperday", ConditionOperator.Equal, 100000000);

//2.Contains  字符串中包含某个字符串
QueryExpression queryExpression = new QueryExpression("stz_workhoursdetail");
queryExpression.ColumnSet = new ColumnSet(true);
queryExpression.Criteria.AddCondition("stz_name", ConditionOperator.Equal, %String_String%);

//3.LastXMonths 前X月
//查找工单
QueryExpression queryExpression = new QueryExpression("stz_work_order");
queryExpression.ColumnSet = new ColumnSet(true);
queryExpression.Criteria.AddCondition("stz_ticket_status", ConditionOperator.Equal, 100000005);
//排序
queryExpression.AddOrder("createdon", OrderType.Ascending);
queryExpression.Criteria.AddCondition("createdon", ConditionOperator.LastXMonths,3);