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.
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.