For some reason when we use the Table search on any table with source from DSO
we get this error: There was an error performing the requested search. there was an error making a request against the database: invalid input syntax for type numeric:
For some reason it's expecting numeric values only
it use to work fine, and was able to search anything (number or text)
If i try to specify the search fields (example 1 text field and 1 numeric field), I get same error when searching any text
if in search field i specify the text field only or numeric field only, it works
Any ideas on how i can search by default all fields as it's suppose to be?