crm OData查询条件设置

crm OData查询条件设置

//下拉框等于某个值
var result = "new_month/Value eq 7";
//下拉框不等于某个值
var result = "new_month/Value ne 7";
//下拉框包含数据
var result = "new_month/Value ne null";
//下拉框不包含数据
var result = "new_month/Value eq null";

//金额字段等于
var result = "new_budgetsum/Value eq 1";
//金额字段不等于
var result = "new_budgetsum/Value ne 1";
//金额字段大于
var result = "new_budgetsum/Value gt 1";
//金额字段大于等于
var result = "new_budgetsum/Value ge 1";
//金额字段小于
var result = "new_budgetsum/Value lt 1";
//金额字段小于等于
var result = "new_budgetsum/Value le 1";
//金额字段包含数据
var result = "new_budgetsum/Value ne null";
//金额字段不包含数据
var result = "new_budgetsum/Value eq null";

 

var id = "4186C339-E4FD-E311-B87B-5443A2E5810E";
//主键等于
var result = "new_bugetId eq guid'"+ id +"'";
//lookup字段等于
var result = "new_cost_centerid/Id eq guid'" + id +"'";
//lookup字段不等于
var result = "new_cost_centerid/Id ne guid'" + id +"'";
//lookup字段包含数据
var result = "new_cost_centerid/Id ne null";
//lookup字段不包含数据
var result = "new_cost_centerid/Id eq null";