im designing a data table page from a CRM system with complicated advanced search（up to 10 fields?）.
The table display information from a very large amount of data, to avoid losing any of them, users can only pick data from a limited time range(30 days).
THE scenario is, we also allow user to search data with an unique ID(exact match).and when they do so, any other search settings including time limit are unnecessary.So now our solution is invalidate other search settings in backstage when user type something in ID field and hit search. But im pretty sure this solution violate several usability rules.
How can i do?