# 运算符相关示例
#### 嵌套and、or和in
查询"名称"为"张三"，且"创建者"为"李四"或"修改者"为"王五"、"赵六"的记录。示例如下：
```
{
    "params": {
        "sort": "desc",
        "orderBy": "name",
        "filter": {
            "joiner": "and",
            "conditions": [
                {
                    "conditionName": "name",
                    "operator": "=",
                    "conditionValues": [
                        "张三"
                    ]
                },
                {
                    "joiner": "or",
                    "conditions": [
                        {
                            "conditionName": "creator",
                            "operator": "=",
                            "conditionValues": [
                                "李四"
                            ]
                        },
                        {
                            "conditionName": "modifier",
                            "operator": "in",
                            "conditionValues": [
                                "王五",
                                "赵六"
                            ]
                        }
                    ]
                }
            ]
        }
    }
}
```
如上示例可得出如下查询语句：
```
(name=张三)  and （ (creator=李四) or (modifier in (王五, 赵六) ) ) order by name desc
```
其中，"joiner"用于控制相同层次的"conditions"间的关系。
#### 单个条件
- 示例1：
  ```
  {
      "params": {
          "sort": "desc",
          "orderBy": "name",
          "filter": {
              "conditionName": "name",
              "operator": "=",
              "conditionValues": [
                  "张三"
              ]
          }
      }
  }
  ```
  
- 示例2：
  ```
  {
      "params": {
          "sort": "desc",
          "orderBy": "name",
          "filter": {
              "joiner": "and", // and或者or
              "conditions": [
                  {
                      "conditionName": "name",
                      "operator": "=",
                      "conditionValues": [
                          "张三"
                      ]
                  }
              ]
          }
      }
  }
  ```
  
 
#### 模型自身属性
支持使用ConditionName和orderBy字段。如果输入的入参不是该模型的属性，会提示错误。其错误示例如下所示：
```
{
    "result": "FAIL",
    "data": [],
    "errors": [
        {
            "code": "rdm.coresdk.unknown.exception",
            "message": "unknown exception",
            "detailMessage": "org.hibernate.QueryException: could not resolve property: string of: com.example.it.rdm.bean.module.DM0829002 [from com.example.it.rdm.bean.module.DM0829002 p left join fetch p.master  where p.rdmDeleteFlag = 0  and UPPER(p.string) = UPPER('string') and p.latest = '1' order by p.id desc]"
        }
    ]
}
```
其中，"could not resolve property: string"为具体错误的属性名称。
#### ISNULL和NOTNULL传参
```
{
    "params": {
        "sort": "desc",
        "orderBy": "name",
        "filter": {
            "joiner": "and", // 或者or
            "conditions": [
                {
                    "conditionName": "name",
                    "operator": "ISNULL", // 或者NOTNULL 
                    "conditionValues": [  // conditionValues可不写
                        "张三"
                    ]
                }
            ]
        }
    }
}
```
#### 参考对象
假设TestQuery的参考对象是SimpleEntity（别名为ref），SimpleEntity的别名为ref，有Long类型的ID字段和String类型的Name字段。用户希望对SimpleEntity过滤ID，其示例代码如下所示：
```
{
    "params": {
        "filter": {
            "joiner": "and",
            "conditions": [
                {
                    "conditionName": "ref.id",
                    "operator": "=",
                    "conditionValues": [
                        "406889137980243968"
                    ]
                }
            ]
        }
    }
}
```
如需过滤其他属性，基于新增过滤条件即可。
#### 扩展属性
扩展属性的固定前缀为"extAttrs"，格式有"extAttrs.扩展属性名"和"extAttrs.扩展属性名.value"两种。其中，"extAttrs.扩展属性名.value"适用于自定义精度的扩展属性。
```
{
    "params": {
        "filter": {
            "joiner": "and",
            "conditions": [
                {
                    "conditionName": "extAttrs.extAttrName1",
                    "operator": "=",
                    "conditionValues": [
                        "406889137980243968"
                    ]
                },
{
                    "conditionName": "extAttrs.extAttrName2.value",
                    "operator": "=",
                    "conditionValues": [
                        "12.133"
                    ]
                }
            ]
        }
    }
}
```
#### 分类属性
分类属性的固定前缀为"clsAttrs"，格式有"clsAttrs.分类名.分类内属性名"和"clsAttrs.分类名.分类内属性名.value"两种。其中，"clsAttrs.分类名.分类内属性名.value"适用于自定义精度的分类属性。
```
{
    "params": {
        "filter": {
            "joiner": "and",
            "conditions": [
                {
                    "conditionName": "clsAttrs.clsAttrName.attrName1",
                    "operator": "=",
                    "conditionValues": [
                        "123"
                    ]
                },
{
                    "conditionName": "clsAttrs.clsAttrName.attrName2.value",
                    "operator": "=",
                    "conditionValues": [
                        "12.123"
                    ]
                }
            ]
        }
    }
}
```
#### 扩展类型+扩展属性/分类属性
扩展类型+扩展属性/分类属性的固定前缀为"clsAttrs"，格式有"clsAttrs.分类名.分类内属性名"和"clsAttrs.分类名.分类内属性名.value"两种。其中，"clsAttrs.分类名.分类内属性名.value"适用于自定义精度的扩展类型+扩展属性/分类属性。如需查询此类属性，需额外增加一个过滤条件（rdmExtensionType），用于指明具体的扩展类型。
以"services/dynamic/api/Test0928001/find/20/1"的URI为例：
```
{
    "params": {
        "sort": "DESC",
        "orderBy": "lastUpdateTime",
        "filter": {
            "joiner": "and",
            "conditions": [
                {
                    "conditionName": "clsAttrs.A0001.Testz",
                    "operator": "like",
                    "conditionValues": [
                        "WWW"
                    ]
                },
                {
                    "conditionName": "rdmExtensionType",
                    "operator": "=",
                    "conditionValues": [
                        "Test0928001"
                    ]
                }
              ]
        },
        "isNeedTotal": false
    }
}
```
#### 多字段排序
多字段排序一般使用"sorts"字段表示，其结构如下：
```
{
    "sorts": [
            {
                "sort": "DESC",
                "orderBy": "description"
            }，
            {
                "sort": "ASC",
                "orderBy": "name"
            }
        ]
}
```
使用"sorts"字段后，将按照其列表顺序进行排序。如上所示，对象会先按照"description"进行倒序排序，再按照"name"进行正序排序。
以"services/api/SZAPITEST202211280329/find/20/1"的URI为例，使用如下接口进行多字段排序。
- Find接口：
  ```
  {
      "params": {
          "sorts": [
              {
                  "sort": "DESC",
                  "orderBy": "description"
              }，
              {
                  "sort": "ASC",
                  "orderBy": "name"
              }
          ],
          "filter": {
              "joiner": "and",
              "conditions": [
                  {
                      "conditionName": "description",
                      "operator": "=",
                      "conditionValues": [
                          "a"
                      ]
                  },
                  {
                      "conditionName": "rdmDeleteFlag",
                      "operator": "=",
                      "conditionValues": [
                          "0"
                      ]
                  }
              ]
          }
      }
  }
  ```
  
- Query接口：
  ```
  {
      "params": {
          "sorts": [
              {
                  "sort": "DESC",
                  "orderBy": "description"
              },
              {
                  "sort": "ASC",
                  "orderBy": "name"
              }
          ],
          "filter": {
              "joiner": "and",
              "conditions": [
                  {
                      "conditionName": "description",
                      "operator": "=",
                      "conditionValues": [
                          "a"
                      ]
                  },
                  {
                      "conditionName": "rdmDeleteFlag",
                      "operator": "=",
                      "conditionValues": [
                          "0"
                      ]
                  }
              ]
          }
      }
  }
  ```
  
- Select接口：
  ```
  {
      "params": {
          "selectedField": [
              {
                  "name": "name",
                  "nameAs": "nameAsName"
              },
              {
                  "name": "description",
                  "nameAs": "nameAsDescription"
              },
              {
                  "name": "creator"
              },
              {
                  "name": "id"
              }
          ],
          "sorts": [
              {
                  "sort": "DESC",
                  "orderBy": "name"
              },
              {
                  "sort": "asc",
                  "orderBy": "id"
              }
          ],
          "filter": {
              "joiner": "and",
              "conditions": [
                  {
                      "conditionName": "description",
                      "operator": "=",
                      "conditionValues": [
                          "a"
                      ]
                  }
              ]
          }
      }
  }
  ```