字符串类型

包含

"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"]
datetime：["2021-08-25 00:00:00", "2021-08-25 23:59:59"]

=

"advancedDate"

{"endTime": {"type": "unlimited"},
"startTime": {
"type": "fixed",
"val": "2021-08-18"}
}

[null]

<=

"advancedDate"

{
endTime: {type: "fixed", val: "2021-08-25"},
startTime: {type: "unlimited"}
}{}

[null]