SearchSort FilterExpression Numeric Data

T. Philip Perlman T. Philip Perlman asked Mar 29, 2018
Active Apr 2 · Viewed 2483 times
<p>I have an instance of SearchSort on a page and it is setup with a filter expression that works great for string data. But I would also like to allow users to find a specific record by ID (int). This works fine when the input data is numeric, but when text is put in to search another field it results in an error because an ID (int) field can't be an alphanumeric string. I tried various tsql functions like ISNUMERIC() and C# ToString() but I can't figure out how the processor in the XMOD code handles the various WHERE clauses. </p> <p><br> </p> <p>Any ideas on how to create a FilterExpression that searches numeric and varchar columns with alphanumeric strings? </p>

1 Answer

Loading answers...