操作符 | 参数个数 | 举例 | 说明 |
---|---|---|---|
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/cloudgroups'
{
"cloudgroups": [
{
"brand": "string",
"can_delete": true,
"can_update": true,
"cloudaccount": "string",
"cloudaccount_id": "string",
"cloudpolicies": [
{
"id": "string",
"name": "string"
}
],
"cloudpolicy_count": 0,
"clouduser_count": 0,
"cloudusers": [
{
"id": "string",
"name": "string"
}
],
"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",
"domain_src": "local",
"external_id": "string",
"iam_login_url": "string",
"id": "string",
"imported_at": "2019-08-24T14:15:22Z",
"is_emulated": true,
"is_public": true,
"manager": "string",
"manager_id": "string",
"metadata": {
"property1": "string",
"property2": "string"
},
"name": "string",
"progress": 0,
"project_domain": "string",
"provider": "string",
"public_scope": "string",
"public_src": "local",
"shared_domains": [
{
"id": "string",
"name": "string"
}
],
"shared_projects": [
{
"domain": "string",
"domain_id": "string",
"id": "string",
"name": "string"
}
],
"source": "string",
"status": "string",
"update_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"update_version": 0,
"updated_at": "2019-08-24T14:15:22Z"
}
],
"limit": 0,
"offset": 0,
"total": 0
}