You need to enable JavaScript to run this app.
导航
数据行列权限操作符
最近更新时间:2022.10.27 19:45:04首次发布时间:2022.10.27 19:45:04
opvalOptionval
字符串类型
包含"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]