I am using SQL command: SELECT column1 AS displaytext, Box2D(columngeometry) AS bbox FROM chosenlayer WHERE column2 ILIKE '%?%';
The search box works for most features, and returns nothing for other features. For some features, it will return display text if part of column2 is typed, but returns nothing if the entire column2 value is inserted, whereas, other features return column1 as display text regardless of how complete or incomplete the column2 value is.
All features in column1 are text and all features in column2 are a 6 digit number.
I have created a view within dbmanager but can not figure out how to "talk" to it within from the web. When I execute the same SQL command as shown above in dbmanager all features are returned (none missing).
Does anyone have any ideas on possible solutions to this problem?