数据查询

查询采用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 

同一行是等价的