Servoy Forum

I am using svySearch in my form and I am getting inconsistent results on my searching; especially when trying to search for integers.

For example, I have 10 invoice numbers starting with 107 (one of them is 10790); I only get a result from the search when I type in the whole '10790'.

This implies that the search has setImpliedSearch() is false for integer columns, even when I explicitly set it to true. I have tried this with the invoice number being the only search provider (there is no relationship involved) and with others.

Hi Roddy,

Thanks for using the SvySearch API.

What you observe is expected behavior for a numeric/integer field. All comparisons must be made in the database, so for text columns we can have a "starts-with" or "contains" functionality. But for a numeric column, the search will automatically switch to an exact match.

You could try a modifier that will work on a numeric, such as 1000...1999.

"implied" search means that a user doesn't have to type the column's alias in the search. When set to false, user must type it, i.e. "orderid:10249". It has no effect on the results of the search.