Join the Community

Home
Directory
Events

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Filtering Data with 'AND' and 'OR' Conditions for Email Queries

·

·

Is it possible to filter with 'and' and 'or'? I want to filter a table based on it having a valid email and emails sent = 0 or emails sent = empty

2 comments

Channeled
APP
·
·
You can use filter groups to combine multiple conditions with both AND and OR logic: 1. Click the Filters icon in your table's top menu 2. Click "+ Add filter group" 3. Select AND as the group logic (for valid email condition) 4. Add your first filter for valid email using "is not empty" 5. Add a nested filter group with OR logic 6. Inside this nested group, add two filters: • Emails sent equal to 0 • Emails sent is empty Filter groups can be layered up to two levels deep, perfect for your complex filtering needs.
Sources: Customize your table view | Documentation | Clay University Customize your table view | Documentation | Clay University Logical operators | Documentation | Clay University Logical operators | Documentation | Clay University Comparison operators | Documentation | Clay University
Jonathan M.
·
·
Perfect, thank you

Filtering Data with 'AND' and 'OR' Conditions for Email Queries | Clay