# How do you build advanced search in Adalo?

Build transparent Adalo search with text input, Contains filters, structured filters, deliberate AND/OR rules, empty states, and repeatable diagnostics.

- Canonical URL: https://adalocado.com/answers/advanced-search
- Verification: Verified from current public evidence
- Topic: Lists, Filters, and Search
- Skill level: Intermediate
- Last reviewed: 2026-08-16
- Index status: index-now

## Short answer

Bind a list filter to a search input using a text Contains operator, then layer only the additional filters users need. Test each rule independently before combining them.

Prove the base list before connecting the search input. Add one Contains rule, test realistic partial terms, and then layer only the structured filters users actually need. Contains is case-insensitive substring matching, not a relevance engine. Define empty-query, no-result, and reset behavior explicitly; use Collection Permissions for access control. If discovery requires fuzzy matching, ranking, or a large corpus, validate whether Adalo list filtering is still the right search layer.

## Intended outcome

A search experience that returns understandable results and handles empty queries.

## Requirements

- Search input
- List connected to a collection
- Searchable text properties

## Step by step

1. **Prove the base list**

   Make sure all expected records render before adding search.

2. **Add a search input**

   Give it a clear label or placeholder that names what can be searched.

3. **Filter with Contains**

   Compare a searchable property to the input value with Contains for ordinary text matching.

4. **Layer structured filters**

   Add category or status filters one at a time using deliberate AND/OR logic.

5. **Design no results**

   Show a useful reset or question path when nothing matches.

## Why it works

- Contains is case-insensitive and more forgiving than exact text equality, but it is substring matching rather than fuzzy search or relevance ranking.
- Multiple list filters can use AND/OR logic; conditional visibility remains a separate concern.
- Collection Permissions still govern whether a record is available to search, regardless of what the list filter displays.

## Data model

| Collection | Properties | Relationships |
| --- | --- | --- |
| Searchable items | Name, Description, Status | Optionally belongs to categories and owners |
| Categories | Name | Has many searchable items |

## Common failures

### No records show for an empty query

Define how an empty input should behave and test whether the filter needs a default or alternate list state.

### Search becomes slow as data grows

Reduce searchable fields and filter depth, keep the row light, and validate whether Adalo list filtering is still the right search layer.

## Testing checklist

- [ ] A common partial term returns the known matching sample records.
- [ ] The empty query has intentional behavior and never strands the user.
- [ ] Each structured filter works alone before filters are combined.
- [ ] Records denied by Collection Permissions never appear through search.
- [ ] Common partial terms return results
- [ ] Empty query behavior is intentional
- [ ] AND and OR cases use known records
- [ ] Filters can be reset
- [ ] No-results state is useful

## Limitations

- Client-facing list filtering is not a full-text relevance engine and may not scale to every dataset.
- Contains is substring matching; it does not provide fuzzy matching, typo tolerance, or relevance ranking.

## Community evidence

### [How to apply the search bar feature](https://forum.adalo.com/t/how-to-apply-the-search-bar-feature/51673)

The reply describes taking a text input and filtering the desired collection list where a property such as full name contains that input. Boundary: This demonstrates substring filtering, not fuzzy matching, relevance ranking, typo tolerance, or full-text search.

## Sources

- [Adalo filtering](https://help.adalo.com/component-basics/conditions-and-filtering/filtering-in-adalo)
- [Adalo app performance](https://help.adalo.com/performance/optimize-app-performance)
- [Adalo collection permissions](https://help.adalo.com/database/collection-permissions)
- [Adalo forum: search input and Contains](https://forum.adalo.com/t/how-to-apply-the-search-bar-feature/51673)

Markdown version: https://adalocado.com/answers/advanced-search.md