Current Behavior:
The Filter component automatically triggers linked queries whenever filter values change. This means queries fire on every keystroke, creating excessive database triggers.
Requested Feature:
Add two configuration options to the Filter component:
-
Debounce Input - Add a debounce time setting (in milliseconds) that delays filter execution until the user stops typing. Prevents queries from firing on every keystroke while maintaining auto-filter behavior
-
Manual Trigger Mode - Add a toggle for "Manual trigger" mode. When enabled, filters don't automatically trigger queries. Provides an "Apply Filters" button (similar to the existing "Clear Filters" button). Queries only execute when the user explicitly clicks "Apply"
Benefits:
-
Reduces unnecessary database load
-
Improves user experience for text-based filters
-
Provides flexibility for different use cases (auto-filter vs. manual apply)
Use Case:
In our operations app, we have a complex filter system with text search, dropdowns, and date ranges that query large order tables. Users often want to set multiple filters before seeing results, but currently each filter change triggers queries immediately, creating a poor experience.