| op | valOption | val | |
|---|---|---|---|
| 字符串类型 | |||
| 包含 | "like" | {fuzzyLikePattern: "Contain"} | ["234", "34234", "23423"] |
| 不包含 | "not like" | {fuzzyLikePattern: "Contain"} | ["123", "234"] |
| 以…开始 | "like" | {fuzzyLikePattern: "StartWith"} | ["123", "234"] |
| 以…结束 | "like" | {fuzzyLikePattern: "EndWith"} | ["123", "234"] |
| 数值类型 | |||
| 大于 | ">" | {} | [1] |
| 大于等于 | ">=" | {} | [1] |
| 小于 | "<" | {} | [1] |
| 小于等于 | "<=" | {} | [1] |
| 区间 | "between" | {endpointClosed: [true, true]} | [1, 3] |
| 区间 | "between" | {endpointClosed: [false, false]} | [1, 3] |
| 区间 | "between" | {endpointClosed: [false, true]} | [1, 3] |
| 区间 | "between" | {endpointClosed: [true, false]} | [1, 3] |
| 为空 | "is null" | {} | [null] |
| 不为空 | "is not null" | {} | [null] |
| like 'array<%>'类型 | |||
| ArrayHas | "arrayHas" | {} | ["1", "2"] |
| NotArrayHas | "notArrayHas" | {} | ["1", "2"] |
| 时间类型date和datetime | |||
区间 | "between" | {} | date：["2021-08-25", "2021-08-25"] |
>= | "advancedDate" | {"endTime": {"type": "unlimited"}, | [null] |
<= | "advancedDate" | { | [null] |