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

Recommend AI Automation Templates

Automation Call to Third-Party AI Platform for Text-to-Speech

This template lets you automatically convert text to MP3 by calling a third‑party AI text‑to‑speech platform. Store scripts, lessons, or support content in a table, switch the status to start conversion, and get MP3 files back in the record without any manual audio editing. Use it for video narration, online courses, podcast scripts, product demos, and language learning audio so creators, educators, and training teams can scale content production with a simple, automated text‑to‑speech workflow.

Coming soon

Automatic subtitling for YouTube URLs

Automatically extract and create subtitles from YouTube videos using our powerful automatic subtitling and auto caption tool. Improve video accessibility, streamline subtitle recognition, and manage YouTube content effortlessly. Perfect for creators, marketers, and managers who need fast subtitle creation, accurate YouTube subtitle extraction, and automatic video captions—all in one seamless workflow powered by Bika.ai.

Coming soon

AI Automated Task Management

Helps teams efficiently manage weekly tasks. Through a series of automation tools, including task summaries, progress reminders, and personal summary reports, team members can promptly obtain task information and progress, thereby improving collaboration efficiency and work transparency. By using these automation features, teams can maintain efficient operations and ensure that each member has a clear understanding and sense of responsibility for their tasks.

AI VAT Invoice Information Recognition (China)

This AI VAT Invoice Information Recognition (China) template uses Baidu AI Cloud to deliver AI invoice extraction and end‑to‑end invoice workflow automation for Chinese VAT invoices. Automatically recognize key fields, verify invoices, and write results into your database to streamline financial data management. Support supplier invoice processing and purchase order invoices in the same flow, reducing manual input, lowering error rates, and helping finance teams, SMEs, accountants, and procurement departments keep VAT invoice records accurate, searchable, and audit‑ready.

AI News Anchor

Provide one or more RSS feed URLs and get a concise, 3–5 minute daily news brief. The agent reads the feeds, selects key updates, and summarizes them in a neutral anchor tone with source links.

Content Marketing for SEO

Use the Content Marketing for SEO template as a powerful content strategy template to streamline SEO content management and content workflow management from idea to publication. This content marketing automation setup helps you align content with SEO keywords, manage personas for persona based marketing, and track every step in a visual content marketing dashboard and content performance dashboard. Improve online visibility by organizing topics, workflows, and campaigns in one place so your team can plan, produce, and optimize SEO content more efficiently.

Filter Query Language

Recommend AI Automation Templates

On this page