Limitations of Search when using multiple filters.
Limitations of Search when using multiple filters.
Basically I have a table with about 15 columns that I have been coding to allow multiple values to be filtered in each column using select menus. I've gotten to the point where it works great when only filtering up to 4 or 5 columns, then starts to remove all results. While testing, I am making sure the values are still available to be shown before trying to filter another column, and I am using regex and combine multiple items selected into a string separated by a | - but that doesn't seem to matter.
My multiple select menu's work by passing the values after the user presses a button to apply the filter, so that shouldn't be the issue unless I am missing something.
I'll first start off by saying that although I've looked and found alternatives like plugins to improve searching within Datatables, I'd like to see if it is possible to complete without starting over. Are there inherit limitations to the combinations of searches, or, when done correctly, is it possible to combine multiple input fields and select boxes to narrow down the content?