Skip to content

Full-Text Search

Full-text search finds records by matching keywords against names, emails, subjects, and other text fields. Results are returned instantly.

Full-text search results

How It Works

When you search by keyword, Outsprint queries your CRM database using PostgreSQL full-text search. This is optimized for:

  • Exact matches -- Searching "Sarah Chen" finds that exact contact
  • Prefix matching -- Typing "Sar" matches "Sarah"
  • Quoted phrases -- Searching "Acme Corp" matches that exact phrase

Results typically return in under 50 milliseconds.

What Gets Searched

Full-text search looks across all entity types:

Entity Searchable fields
Contacts Name, email
Companies Name, domain
Deals Deal name, description
Tickets Subject, description

Search via Slash Commands

Slash commands use full-text search for instant results:

You
/contacts sarah
Outsprint AI
Found 3 contacts matching "sarah".

Advanced Filters on Results

When search results are displayed in a table, you can apply additional filters:

  • Lifecycle stage -- Filter by lead status (e.g., SQL, MQL)
  • Owner -- Filter by assigned team member
  • Tags -- Filter by tag
  • Date range -- Filter by creation date or last activity
  • Custom properties -- Filter by any custom field you have defined

Filter Operators

Field type Available operators
Text contains, equals, starts with, is empty
Number equals, greater than, less than, between
Date is, before, after, between, last N days
Select is, is not, is any of
Boolean is true, is false

Pro Tip

Combine slash command search with filters for precise results. For example, /contacts sarah then filter by tag "Enterprise" to narrow down.

What's Next