Filter Condition/Criteria
Filter Conditions (also called Filter Criteria) in Salesforce are logical expressions used to narrow down which records are displayed, processed, or included in a result set.
Definition
Filter Conditions (also called Filter Criteria) in Salesforce are logical expressions used to narrow down which records are displayed, processed, or included in a result set. They consist of three parts: a field name, an operator (such as equals, not equal to, contains, starts with, greater than, less than, or IN), and a value. Filter conditions are used throughout the platform, including in report filters, list views, workflow rules, Flow decision elements, validation rules, SOQL WHERE clauses, and process criteria. Multiple filter conditions can be combined using AND/OR logic.
In plain English
“A Filter Condition is a simple rule that narrows down which records get returned or processed. You pick a field, pick an operator like 'equals' or 'greater than', and provide a value. You can combine multiple conditions with AND/OR logic. They're used everywhere: reports, list views, validation rules, flows, SOQL.”
Worked example
An admin at Glenburn Hospitality builds a workflow rule that fires when a Reservation reaches "Confirmed" status. The Filter Condition is: Status equals "Confirmed" AND CheckIn_Date__c is in the next 7 days AND Confirmation_Sent__c equals false. All three conditions must be true (combined with AND) for the rule to fire and send a confirmation email. The same Filter Conditions appear in report filters, list views, validation rules, Flow decision elements, and SOQL WHERE clauses. Filter Conditions are the platform's universal expression-language for narrowing record sets.
Why Filter Condition/Criteria matters
Filter Conditions (also called Filter Criteria) in Salesforce are logical expressions used to narrow which records are displayed, processed, or included in a result set. Each condition consists of three parts: a field, an operator (equals, not equal, contains, starts with, greater than, less than, IN, and others), and a value to compare against. Multiple conditions can be combined with AND/OR logic for more complex filtering.
Filter Conditions are one of the most universally used constructs in Salesforce. They appear in report filters, list view filters, workflow rule criteria, Flow decision elements, validation rule formulas, SOQL WHERE clauses, process criteria, and many other places. Learning to write effective filter conditions is foundational to Salesforce work. The AND/OR combination logic is especially important: understanding how to express 'any of these conditions' versus 'all of these conditions' versus more complex combinations like '(A OR B) AND C' is a core skill for building anything beyond trivial filtering.
How organizations use Filter Condition/Criteria
Uses filter conditions throughout their reports and list views, building complex combinations with AND/OR logic to surface exactly the records each team needs.
Trains new admins heavily on filter logic because getting the AND/OR combinations right is foundational to building useful reports and automation.
Documents the standard filter patterns their team uses (like 'active high-value accounts') as reusable examples for new team members.
Test your knowledge
Q1. What is a Filter Condition?
Q2. Where do you use Filter Conditions?
Q3. Why does AND/OR logic matter?
Discussion
Loading discussion…