String type

Contains

"like"

{fuzzyLikePattern: "Contain"}

["234", "34234", "23423"]

Does not contain

"not like"

{fuzzyLikePattern: "Contain"}

["123", "234"]

Starts with

"like"

{fuzzyLikePattern: "StartWith"}

["123", "234"]

Ends with

"like"

{fuzzyLikePattern: "EndWith"}

["123", "234"]

Numeric type

Greater than

">"

{}

[1]

Greater than or equal to

">="

{}

[1]

Less than

"<"

{}

[1]

Less than or equal to

"<="

{}

[1]

Range

"between"

{endpointClosed: [true, true]}

[1, 3]

Range

"between"

{endpointClosed: [false, false]}

[1, 3]

Range

"between"

{endpointClosed: [false, true]}

[1, 3]

Range

"between"

{endpointClosed: [true, false]}

[1, 3]

Is null

"is null"

{}

[null]

Is not null

"is not null"

{}

[null]

Like array<%> type

ArrayHas

"arrayHas"

{}

["1", "2"]

NotArrayHas

"notArrayHas"

{}

["1", "2"]

Date and datetime type

Range

"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]