查询条件

## 查询条件
数据集查询条件包
```
{
"pageNum":1,
"pageSize":10,
"__searchField":"字段名",##查找定义字段
"__searchTreeFilter":false,##查找定义模型树过滤
"__zcQuery":false,##发起从表查询
"__slaveEntities":[
    {
    "modelFilePath":"数据集业务路径",
    "pageSize":-1,##页大小
    "__body":{},##从表条件
    "__slaveEntities":[]
    }
],
"__returnCount":false,
"__bottomSummary":false,
"__queryPlanId":"查询方案id",
"__queryFields":['aFieldN','aFieldN'],
"modelFilePath":"数据集业务路径",
"__funcpath":"功能路径",
"__body":{
    "FC1":"avalue",
    "FC2":"avalue",
    "distinct":["afieldN","otherFieldN"],
    "queryCdions": {
        "join": "and|or",
        "items": [
            {
                "sign": "eq|in|notIn|notInEx|lt|gt|like|likeLeft|
                notlikeLeft|likeRight|notlikeRight|inRange|outRange|
                between|lteq|gteq|noteq|isnull|isnotnull",
                "name": "aname",
                "desc": "adesc",
                "value": "avalue",
                "value2": "avlue2"
            },
            {
                "join": "and|or",
                "items": []
            }
        ]
    },
    "orderBy": [
        {
            "name": "aname",
            "desc": "adesc",
            "type": "asc|desc"
        }
    ],
    "groupBy": "agroupField,agroupField",
    "statFields":"astatField,astatField",
    "havingCdions": {
        "join": "and|or",
        "items": [
            {  
               "sign":"eq|in|notIn|notInEx|lt|gt|like|likeLeft|
                notlikeLeft|likeRight|notlikeRight|inRange|outRange|
                between|lteq|gteq|noteq|isnull|isnotnull",
                "name": "aname",
                "desc": "adesc",
                "value": "avalue",
                "value2": "avalue2"
            },
            {
                "join": "and|or",
                "items": []
            }
        ]
    }
}
}
```

- 查询条件包key值

| Key          | 说明   | 值       | 默认         |
|--------------|------|---------|------------|
| queryCdions  | 查询条件 | {} 树型嵌套 |            |
| orderBy      | 排序   | [] 对象数组 |            |
| groupBy      | 分组依据 | String  | 字段名1,字段名2… |
| havingCdions | 统计条件 | {} 树型嵌套 | 无          |

- queryCdions.item 或 havingCdions.item，条件项

| Key  | 说明   | 值         | 默认   |
|------|------|-----------|------|
| join | 关联类型 | [and,or]  | and  |
| sign | 运算符  | 参考sign枚举值 | like |

- sign,运算符枚举值

| 运算符 | 说明   | 示例                |
|-----|------|-------------------|
| eq  | 等于   | f1=’v1’           |
| in  | 在范围内 | f1 in (‘v1’,’v2’) |

- 当queryCdions.item.sign=‘between’, value时间枚举有效

| Key       | 说明 | 示例                                                         |
|-----------|----|------------------------------------------------------------|
| yesterday | 昨日 | f1 between “2019-05-29 00：00：00” and “2019-05-29 23：59：59” |
| week      | 本周 | f2 between “2019-05-19 00：00：00” and “2019-05-25 23：59：59” |

yesterday(“昨日”), today(“本日”), week(“本周”), month(“本月”), quarter(“本季度”), year(“本年度”), days7(“近7天”), days28(“近28天”), days84(“近84天”), halfyear(“近半年”), oneyear(“近一年”);