Currently, lookup filtering in model‑driven app views requires users to manually enter search text before results are returned. This behavior has been confirmed as aligned with the current product design, especially to optimize performance in environments with large datasets.

However, this change has introduced usability challenges for customers who previously relied on the ability to view and select lookup values directly without manual input.

Additionally, lookup filtering performance can be impacted by overall environment data volume, indexing, and related entities, not just the lookup table itself, leading to slower response times even when the lookup dataset is small.

Suggested Improvements

Provide an optional configuration setting to:

• Enable/disable automatic dropdown value display for lookup filters
• Improve lookup query performance optimization to reduce latency in high‑volume environments
• Allow administrators to control search behavior thresholds (e.g., minimum characters required)
• Provide better visibility/documentation on how environment data impacts lookup performance

Business Impact

• Enhances usability for users performing frequent filtering
• Reduces friction introduced by required manual input
• Improves performance transparency and configurability
• Aligns product behavior with prior user expectations