数据查询

查询采用json格式的表达式，格式：

{
  "filters": [{"name": "age", "op": "lt", "val": 20}, ...],
  "order_by": [{"field": "age", "direction": "desc"}, ...]
  "limit": 10,
  "offset": 3
}

示例：

{"filters": [{"name": "name", "val": "%admin%", "op": "like"}]}
{"filters": [{"name": "name", "val": "%admin%", "op": "like"}], "offset": 20, "limit": 20}
{"filters": [{"name": "name", "val": "%admin%", "op": "like"}], "order_by": [{"field": "name", "direction": "asc"}]}
{"order_by": [{"field": "name", "direction": "asc"}]}

参数介绍

filters

查询的过滤，格式如下:

{"name": 字段名, "op": 操作符, "val": 参数}
或: 
{"name": 字段名, "op": 操作符, "field": 字段名} 

limit

返回的最大条目数.

offset

记录偏移位置.

order_by

排序方式，格式如下:

{"field": 字段名, "direction": 排序方式}
排序方式："asc" | "desc

Operators

查询操作符:

==, eq, equals, equals_to 
!=, neq, does_not_equal, not_equal_to 
>, gt, <, lt 
>=, ge, gte, geq, <=, le, lte, leq 
in, not_in 
is_null, is_not_null 
like 
has 
any 

同一行是等价的

数据查询

查询采用json格式的表达式，格式：

{
  "filters": [{"name": "age", "op": "lt", "val": 20}, ...],
  "order_by": [{"field": "age", "direction": "desc"}, ...]
  "limit": 10,
  "offset": 3
}

示例：

{"filters": [{"name": "name", "val": "%admin%", "op": "like"}]}
{"filters": [{"name": "name", "val": "%admin%", "op": "like"}], "offset": 20, "limit": 20}
{"filters": [{"name": "name", "val": "%admin%", "op": "like"}], "order_by": [{"field": "name", "direction": "asc"}]}
{"order_by": [{"field": "name", "direction": "asc"}]}

参数介绍

filters

查询的过滤，格式如下:

{"name": 字段名, "op": 操作符, "val": 参数}
或: 
{"name": 字段名, "op": 操作符, "field": 字段名} 

limit

返回的最大条目数.

offset

记录偏移位置.

order_by

排序方式，格式如下:

{"field": 字段名, "direction": 排序方式}
排序方式："asc" | "desc

Operators

查询操作符:

==, eq, equals, equals_to 
!=, neq, does_not_equal, not_equal_to 
>, gt, <, lt 
>=, ge, gte, geq, <=, le, lte, leq 
in, not_in 
is_null, is_not_null 
like 
has 
any 

同一行是等价的