Filter Query Language
Expression Structure
Query structure consists of field
, operator
, and value
:
For an expression like name==text
, the structure is explained as follows:
Name | Description |
name
| Field ID or field name. Names with spaces can be wrapped in braces, e.g., {single text} |
==
| Comparison operator. Different field types support different operators, detailed below |
text
| Values with spaces are usually wrapped in double quotes, e.g., name=="text 1" |
Note: field
can only use characters other than system reserved characters, no spaces allowed. If spaces are needed, wrap with braces, e.g., {single text}
System reserved characters:
"
'
(
)
;
,
=
!
~
<
>
\n
\t
\r
Operators
Logical Operators
Logical Operator | Description |
; or and
| AND |
, or or
| OR |
Compound queries combine multiple expressions to form complex query conditions.
Note: Only one type of logical operator can be used in a single query, they cannot be mixed. and
and or
cannot coexist, for example:
✅ Valid: single_text=="text 1";single_text=="text 2";single_text=="text 3"
❌ Invalid: single_text=="text 1";single_text=="text 2",single_text=="text 3"
Comparison Operators
Comparison Operator | Description |
==
| Equal to |
!=
| Not equal to |
>
| Greater than |
<
| Less than |
>=
| Greater than or equal to |
<=
| Less than or equal to |
=c=
| Contains |
=nc=
| Does not contain |
Comparison Values
Usually can be strings/numbers, refer to the examples below:
Example | Type | Description |
text
| string | Text |
"simple text"
| string | Text with spaces, must be wrapped in double quotes |
123
| number | Number |
"123.45"
| number | Float, must be wrapped in double quotes, supports precision matching for number types |
true ,1
| boolean | For checkbox field type cell values, these two can be true |
false ,0
| boolean | For checkbox field type cell values, these two can be false |
null , NULL
| null | Check if cell value is empty, used with == , != for judgment |
("option 1", "option 2")
| array | Array, can be used when cell is represented as array, used with =c= , =nc= , == , != |
Query Examples
Single Line Text Query
Supported operators: ==
, !=
, =c=
, =nc=
Operator | Field Name | Query Example | Description |
Equal to | single_text
| single_text=="simple text"
| Exact match for cells with specified content |
Not equal to | single_text
| single_text!="simple text"
| Exact non-match for cells with specified content |
Contains | single_text
| single_text=c="simple text"
| Cells containing specified content, value must be string |
Does not contain | single_text
| single_text=nc="simple text"
| Cells not containing specified content, value must be string |
Is empty | single_text
| single_text==null or single_text==NULL
| Cell content is empty |
Is not empty | single_text
| single_text!=null or single_text!=NULL
| Cell content is not empty |
Number Query
Supported operators: ==
, !=
, >
, <
, >=
, <=
Operator | Field Name | Query Example | Description |
Equal to | number_field
| number_field==123
| Exact match for cells with specified number |
Not equal to | number_field
| number_field!=123
| Exact non-match for cells with specified number |
Greater than | number_field
| number_field>123
| Cells with numbers greater than specified value |
Less than | number_field
| number_field<123
| Cells with numbers less than specified value |
Greater than or equal to | number_field
| number_field>=123
| Cells with numbers greater than or equal to specified value |
Less than or equal to | number_field
| number_field<=123
| Cells with numbers less than or equal to specified value |
Is empty | number_field
| number_field==null or number_field==NULL
| Cell content is empty |
Is not empty | number_field
| number_field!=null or number_field!=NULL
| Cell content is not empty |
Checkbox Query
Supported operators: ==
Supported values: true
, false
, 1
, 0
Operator | Field Name | Query Example | Description |
Equal to | checkbox
| checkbox==true or checkbox==1
| Query rows with checked cells |
Equal to | checkbox
| checkbox==false or checkbox==0
| Query rows with unchecked cells |
Single Select Query
Supported operators: ==
, !=
, =c=
, =nc=
Operator | Field Name | Query Example | Description |
Equal to | single_select
| single_select=="Option 1"
| Exact match for cells with specified option |
Not equal to | single_select
| single_select!="Option 1"
| Exact non-match for cells with specified option |
Contains | single_select
| single_select=c=("Option 1", "Option 2")
| Cells containing specified options |
Does not contain | single_select
| single_select=nc=("Option 1", "Option 2")
| Cells not containing specified options |
Is empty | single_select
| single_select==null or single_select==NULL
| Cell content is empty |
Is not empty | single_select
| single_select!=null or single_select!=NULL
| Cell content is not empty |
Multi Select Query
Supported operators: ==
, !=
, =c=
, =nc=
Value type: array, e.g., ("Option 1", "Option 2")
Operator | Field Name | Query Example | Description |
Equal to | multi_select
| multi_select==("Option 1", "Option 2")
| Exact match for cells with specified options |
Not equal to | multi_select
| multi_select!=("Option 1", "Option 2")
| Exact non-match for cells with specified options |
Contains | multi_select
| multi_select=c=("Option 1", "Option 2")
| Cells containing specified options |
Does not contain | multi_select
| multi_select=nc=("Option 1", "Option 2")
| Cells not containing specified options |
Is empty | multi_select
| multi_select==null or multi_select==NULL
| Cell content is empty |
Is not empty | multi_select
| multi_select!=null or multi_select!=NULL
| Cell content is not empty |
Date Query
Supported operators: ==
, !=
, >
, <
, >=
, <=
Date comparison values can only be precise to year-month-day, not to hour-minute-second, for example:
✅ Valid: 2023-10-01
❌ Invalid: 2023-10-01 12:00:00
Operator | Field Name | Query Example | Description |
Equal to | date
| date=="2023-10-01"
| Match cell values within specified time |
Not equal to | date
| date!="2023-10-01"
| Do not match cell values within specified time |
Greater than | date
| date>"2023-10-01"
| Cells with dates greater than specified value |
Less than | date
| date<"2023-10-01"
| Cells with dates less than specified value |
Greater than or equal to | date
| date>="2023-10-01"
| Cells with dates greater than or equal to specified value |
Less than or equal to | date
| date<="2023-10-01"
| Cells with dates less than or equal to specified value |
Is empty | date
| date==null or date==NULL
| Cell content is empty |
Is not empty | date
| date!=null or date!=NULL
| Cell content is not empty |
Link Query
Supported operators: ==, !=, =c=, =nc=
Value type: array, e.g., ("record1", "record2")
Operator | Field Name | Query Example | Description |
Equal to | link
| link==("record1", "record2")
| Exact match for specified linked records |
Not equal to | link
| link!=("record1", "record2")
| Exact non-match for specified linked records |
Contains | link
| link=c=("record1", "record2")
| Contains specified linked records |
Does not contain | link
| link=nc=("record1", "record2")
| Does not contain specified linked records |
Is empty | link
| link==null or link==NULL
| Cell content is empty |
Is not empty | link
| link!=null or link!=NULL
| Cell content is not empty |