操作符 | 参数个数 | 举例 | 说明 |
---|---|---|---|
in | > 0 | name.in("test", "good") | 在给定数组中 |
notin | > 0 | name.notin('test') | 不在给定数组中 |
between | 2 | created_at.between('2019-12-10', '2020-01-02') | 在两个值之间 |
ge | 1 | created_at.ge('2020-01-01') | 大于或等于给定值 |
gt | 1 | created_at.gt('2020-01-01') | 严格大于给定值 |
le | 1 | created_at.le('2020-01-01') | 小于或等于给定值 |
lt | 1 | sync_seconds.lt(900) | 严格大于给定值 |
like | > 0 | name.like('%test%') | sql字符串匹配任意一个字符串 |
contains | > 0 | name.contains('test') | 包含任意一个给定字符串 |
startswith | > 0 | name.startswith('test') | 以任意一个给定字符串开头 |
endswith | > 0 | name.endswith('test') | 以任意一个给定字符串结尾 |
equals | > 0 | name.equals('test') | 等于任意一个给定值 |
notequals | 1 | name.notequals('test') | 不等于给定值 |
isnull | 0 | name.isnull() | 值为SQL的NULL |
isnotnull | 0 | name.isnotnull() | 值不为SQL的NULL |
isempty | 0 | name.isempty('test') | 值为空字符串 |
isnotempty | 0 | name.isnotempty('test') | 值不是空字符串 |
isnullorempty | 0 | name.isnullorempty('test') | 值为SQL的NULL或者空字符串 |
curl --location --request GET 'https://example.com:30888/projects'
{
"limit": 0,
"offset": 0,
"projects": [
{
"Organization": {
"Id": "string",
"Keys": [
"string"
],
"Name": "string",
"Nodes": [
{
"Id": "string",
"Labels": [
"string"
]
}
]
},
"admin": "string",
"admin_domain": "string",
"admin_domain_id": "string",
"admin_id": "string",
"can_delete": true,
"can_update": true,
"created_at": "2019-08-24T14:15:22Z",
"delete_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"deleted": true,
"deleted_at": "2019-08-24T14:15:22Z",
"description": "string",
"domain_id": "string",
"ext_resource": {
"property1": 0,
"property2": 0
},
"ext_resources_last_update": "2019-08-24T14:15:22Z",
"ext_resources_next_update": "2019-08-24T14:15:22Z",
"extra": {},
"group_count": 0,
"id": "string",
"is_domain": true,
"is_emulated": true,
"metadata": {
"property1": "string",
"property2": "string"
},
"name": "string",
"parent_id": "string",
"pending_deleted": true,
"pending_deleted_at": "2019-08-24T14:15:22Z",
"project_domain": "string",
"update_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"update_version": 0,
"updated_at": "2019-08-24T14:15:22Z",
"user_count": 0
}
],
"total": 0
}