🎯 Module 10: Criteria & Filters

Week 2 • Saved Searches Fundamentals • Core Skills

The Criteria Subtab

Criteria define which records are included in your saved search results. Each criterion is a filter that evaluates to true or false. Only records where all criteria evaluate to true are returned.

The Filter Equation

Every filter follows the same pattern:

Field Operator Value

💡 Examples

Field Operator Value Meaning
Balance greater than 1000 Balance exceeds $1,000
Status is Open Status equals "Open"
Type is any of Invoice, Credit Memo Type is Invoice OR Credit Memo
Name contains Corp Name includes "Corp"

Common Operators

📋 Operator Reference

Operator Use For Example
isExact matchStatus is Open
is notExclude valueType is not Quote
is any ofMultiple values (OR)State is any of CA, NY, TX
is none ofExclude multipleCategory is none of A, B
containsPartial text matchName contains Inc
does not containExclude textEmail does not contain test
starts withBeginning matchPhone starts with 415
greater thanNumeric comparisonAmount > 5000
less thanNumeric comparisonQuantity < 10
is emptyNull/blank checkEmail is empty
is not emptyHas valuePhone is not empty

Adding Criteria

  1. Navigate to the Criteria subtab
  2. In the Standard sub-subtab, find the Filter dropdown
  3. Select a field to filter on
  4. Select an operator from the dropdown
  5. Enter or select a value
  6. Click Add
  7. Repeat to add additional filters

Editing & Removing Filters

✏️ Modify Existing Filters

💡 Available Filters Subtab

Filters added to the Available Filters subtab appear as dropdowns when users view the search results. This lets users adjust the search without editing the definition. Use this for date ranges, status filters, or any criteria users might want to customize.

🎯 Key Takeaways