Hello,
I am trying to search for a row using a wildcard in structured query. But I
am not able to do that.
Is there a way I can use something like the below to query rows?
ListQuery query = new ListQuery(listFeedUrl);
query.setSpreadsheetQuery("name = John and age > 25 and* lastname like
%mith%* ");
ListFeed feed = service.query(query, ListFeed.class);
The above query brings all records with lasname like "Smith" or "Smiths" or
"miths"
If this feature is not available, is there any other way I can achieve the
same results?
I think this is very important for an API to have this feature to search
using wildcard. I think the Google Visualization API Query Language (
http://code.google.com/apis/chart/interactive/docs/querylanguage.html#Where)
has this "like" keyword.
Thanks!
