Enumeration Operator

操作符列表

datatype	support operator	comment
AutoNumber	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
CheckBox	eq, ne, isnull, isnotnull
Currency	eq, ne, le, ge, lt, gt, in, isnull, isnotnull
Date	eq, ne, le, ge, lt, gt, in, isnull, isnotnull
DateTime	eq, ne, le, ge, lt, gt, in, isnull, isnotnull
Email	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
Formula	isnull, isnotnull
ID	eq, ne, in, isnull, isnotnull
Lookup	eq, ne, in, isnull, isnotnull
MasterDetail	eq, ne, in, isnull, isnotnull
Name	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
Hierarchy	eq, ne, in, isnull, isnotnull
Number	eq, ne, le, ge, lt, gt, in, isnull, isnotnull
Percent	eq, ne, le, ge, lt, gt, in, isnull, isnotnull
Phone	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
SingleSelect	eq, ne, isnull, isnotnull
MultiSelect	eq, ne, includes, excludes, isnull, isnotnull
RollupSummary	sum, min, max, count, isnull, isnotnull
Text	eq, ne, le, ge, lt, gt, contains, startwith, endwith, isnull, isnotnull
TextArea	isnull, isnotnull
URL	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
PostalCode	eq, ne, le, ge, lt, gt, in, contains, startwith, endwith, isnull, isnotnull
EncryptedText	search

• in

in操作符需要传入数组形式的值：

{
   "value": ["hello", "hi"]
}

• search

search 操作仅支持加密可搜索字段，且仅支持前缀匹配，如加密的明文为 ABCDE, 按 ABC 查能匹配， 但是按 BC 查，无法匹配。

同时， 非所有 Option 选项均支持， 仅支持如下选项：

• fields
• skip
• limit