The filter bar searches for exact matches with substrings of searchable values in the table (where value like ‘%search%’). In most cases that is the desired behavior. However in one particular screen we would like to be able to insert the id of a record and only show that one record (where value = ‘search’). The reason for that is it greatly enhances performance. If a quick filter is applied also the same select statement goes down from 1529 ms to 3 ms. This means a refresh of the entire screen would take 1,5 seconds less than it does at the moment. Refreshes are frequent in this screen.
May I suggest a new setting for a filter bar to make this possible? This way a search would perform just a well as a quick filter.
