I had the same issue from the java client. Related note: java samples
ListFeedHelper shows the following syntax for structured query
example:
* Structured queries are in format:
* name = 'adam' and (job = 'technical writer' or job = 'artist')
Parser actually rejects single quotes, but accepts strings without
them, so "name = adam" will work. But how to specify empty cell
without single quotes?
Side note: code example from ListFeedHelper above applies query string
with setFullTextQuery; shouldn't this be setSpreadsheetQuery?
**Solution: Use double quotes. Java example:
ListQuery listQuery = new ListQuery(worksheet.getListFeedUrl());
//set the query this way
listQuery.setStringCustomParameter("sq", "colName=\"\"");
//or this way, they work the same
listQuery.setSpreadsheetQuery("colName=\"\"");
List<ListEntry> rows = service.query(listQuery,
ListFeed.class).getEntries();
John
On Jan 13, 5:54 pm, ASI <[email protected]> wrote:
> I would like a ListQuery that returns all entries that have a empty
> cell for a particular column.
>
> Like this:
> ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
> listQuery.SpreadsheetQuery = "removedon=";
>
> Where my removedon field is blank.
>
> Thanks,
> ASI
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
