Advanced filters 2.0: New operators and improved consistency

We have improved the advanced filtering for smartlists to bring better consistency, clarity, and standardization. Earlier, filters had inconsistent operators across different data types and some commonly expected operators were missing. We have standardized how operators behave across date, numeric, and string filters while cleaning up existing logic. This update also resolves a long-standing issue related to future date filtering. The goal is to standardize filter behavior across data types while improving usability and reducing confusion for users.

Added commonly requested operators for date filters: today, tomorrow, yesterday, this week, this quarter, this year, before date, and after date to the existing set of date operators

Standardized string filter operators to ensure consistent behavior across fields

Introduced DND as a suffix for SMS, email, call, WhatsApp, etc., making communication-related filtering easier.

Renamed Pipeline filters -> Opportunity to better align with terminology commonly used and understood by our customers.

Enhanced email and WhatsApp status operators to better reflect the underlying status criteria and cover additional matching scenarios.

Improved filtering and operators for Numeric fields - added more options.

ets.io/images/eaeb287b87e705bd7b1eb6ca69db4263.png)

What's next:

Continued Performance Improvement for certain filters, especially string operators like contains and is for better efficiency and string matching