Neodeluxe Filter Operators

What Are Filter Operators?

Filter operators help you find specific information in your Neodeluxe data tables. Think of them as filters and search tools that allow you to narrow down what you’re looking for in a list of data. You can use them to:

• Find items containing certain words.
• See only exact matches.
• Filter by whether a field is empty or filled.

Go to the Neodeluxe Toolbar to find more information about Filter.

Types Of Filter Operators

Contains

• What It Does: Shows all results that include the word or phrase.
• When to Use It: If you only remember part of a name or value.
• Example:
  • Searching for "Smith" will show results like
    • Smith Mark
    • Smith Johnson
    • Smith v. United States
  • It will not show John Smyth because the exact sequence “Smith” isn’t there.

Equals

• What It Does: Shows only the exact match you typed.
• When to Use It: If you know the exact value you’re looking for. 
• Example:
  • Searching for “Smith Mark” will only show:
    • Smith Mark
  • It won’t show Mark Smith or Smith Johnson because they aren’t an exact match.

Starts With

• What It Does: Shows results that begin with the text you typed.
• When to Use It: If you know how the name or value starts.
• Example:
  • Searching for “Sm” might show:
    • Smart Decisions
    • Smoke Problems
    • Smith Mark
  • It won’t show Alpha Smith because it doesn’t start with “Sm.”

Ends With

• What It Does: Shows results that end with the text you typed. 
• When to Use It: If you know how the name or value ends.
• Example:
  • Searching for “am” will show:
    • Data Stream
    • Fire Foam
  • It won’t show Smart Decisions because it doesn’t end in “am.”

Is Empty

• What It Does: Shows results where the field has no value at all.
• When to Use It: To find missing or incomplete data.
• Example:
  • If searching in the “Project Name” column, it will show all projects with no name entered.

Is Not Empty

• What It Does: Shows results where the field has any value.
• When to Use It: To find all completed entries.
• Example:
  • If searching in the “Project Name” column, it will show all projects that have a name.

Is Any Of

• What It Does: Shows results that match any of the values listed.
• When to Use It: If you’re looking for multiple possible matches.
• Example:
  • Searching for “Mark Johnson” and “Smith Mark” will show:
    • Mark Johnson
    • Smith Mark
  • It will not show Mark Smith unless you also add that to your search.

Tips for Using Filter Operators

• Combine multiple filters for more detailed searches.
• Start with Contains if you’re unsure of the exact value.
• Use Equals for precise searches.