Comments
This highlights a significant limitation in date filtering behavior for multi-timezone environments. Ensuring that the selected date is preserved consistently, without unintended shifts due to UTC conversion. This would greatly improve data accuracy and usability. Providing configurable options or clearer handling for date-only scenarios would better support global organizations and reduce reliance on impractical timezone-based workarounds.
This highlights a key usability trade-off between performance optimization and user experience in lookup filtering. While requiring manual input may reduce load on large datasets, it introduces friction for common user scenarios. Providing configurable options, such as enabling dropdown preloading, adjusting search thresholds, and improving visibility into performance factors. This would offer much-needed flexibility, allowing organizations to balance performance and usability based on their specific needs.