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=`, `==`, `!=`

Streamline your entire contract lifecycle with the Business Contract Management template. This centralized contract management system serves as an all-in-one contract database and centralized contract repository for tracking contract details, approvals, and activities. Automate key processes through a contract approval workflow and contract workflow management, ensuring accuracy, transparency, and collaboration across teams. Ideal for project contract management, this template simplifies service request tracking, reduces manual work, and improves efficiency from contract submission to expiration reminders.

3-Day Outreach Email Campaign

Quickly launch a 3-day automated email outreach campaign with this ready-to-use email outreach template. Run an email drip sequence of automated welcome emails for new users to boost activation, retention, and early engagement. This workflow helps you send the right message on each of the first three days, pause the sequence when users reply, and avoid over-contacting them. Ideal for customer success teams, SaaS product managers, marketers, and startup founders who want a simple, automated way to guide new users into your product.

Agile Workflow

Use the Agile Workflow template as a centralized project management workspace for your Agile team. Streamline sprint tracking and backlog management, handle backlog prioritization with clear views, and improve project visibility across tasks, stories, and sprints. Built‑in agile automation and automated reminders power daily scrum standups, sprint start and end notifications, and overdue task alerts, helping teams stay aligned, reduce manual follow‑up, and keep every sprint on track.

Auto Send Pay Slips

Automate the entire payroll distribution process with the Auto Send Pay Slips template. Effortlessly send accurate employee pay slips, manage payroll data, and streamline your payroll approval process. Use onboarding form templates, employee roster templates, and payroll sheet templates to keep payroll data management organized and error-free. Generate monthly payroll reports, improve payroll accuracy, and enhance labor cost management as part of automated HR workflows. Ideal as an HR automation tool for HR and finance teams that need reliable, standardized payroll operations.

Automated Birthday Email Celebration

Automate birthday email automation with the Automated Birthday Email Celebration template. Send personalized, automated birthday emails using a flexible birthday email template and automated email template that work with your customer data integration. Use this email scheduling tool to set automated email reminders and schedule birthday marketing emails at the perfect time. Boost customer retention emails and loyalty with B2B email automation and an email personalization tool that delivers timely, relevant birthday email campaigns without manual work.

Customer Sentiment Analysis

Collect, track, and analyze customer feedback and product feedback with this powerful template. Gain actionable marketing insights, monitor customer satisfaction, and implement data-driven improvements. Features include detailed feedback analysis, continuous feedback tracking, and a centralized review system to help businesses enhance customer loyalty and experience.

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

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

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

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

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

Filter Query Language

Filter Query Language

Expression Structure

Operators

Logical Operators

Comparison Operators

Comparison Values

Query Examples

Single Line Text Query

Number Query

Checkbox Query

Single Select Query

Multi Select Query

Date Query

Link Query

Recommend AI Automation Templates

On this page