Universal search
Universal search is a global search capability that allows users to find records across all tables using identifying attributes such as names, emails, and reference numbers.
Instead of navigating through a predefined structure, users can directly target what they are looking for.
What problem it solves
In structured systems, data is distributed across multiple tables and relationships.
Finding a specific record often requires knowing where it is stored and how to navigate to it. This creates friction, especially for users who are not familiar with the data model.
Universal search removes this dependency by allowing users to search across the entire system from a single entry point.
How it behaves
Users enter a search term into a single search field.
The system evaluates the query across multiple tables and identifying attributes, such as:
- names
- email addresses
- phone numbers
- reference numbers
Results are ranked based on relevance and presented in a unified list.
Each result includes key identifying fields, with matching values highlighted to make it clear why the result was returned.
Structural model
Universal search operates on top of the data model rather than replacing it.
- each table contributes searchable attributes
- identifying fields are prioritized in ranking
- relationships are not required for discovery, but can be followed after selection
The search index reflects the structure of the system, but abstracts it away during interaction.
Example
A user is looking for a person but does not know which table contains the record.
They type part of a name into the search field.
The system returns matching results from multiple tables, such as:
- a person record
- a related contact entry
- a reference in another context
The user selects the correct result and is taken directly to that record.