Hi.
I just started working with this API, and i already managed to
retrieve,create, update and delete rows.
The problem i have is that when i need to filter results, i need to iterate
the resultset, check if it is like what i filtered, and then add it to a
new resultset.
What i would like is to get the filtered resultset by using a
spreadsheetquery, but it seems that i'm doing something wrong. I would
really appreciate any help you could give me.
This is the code i'm using:
private void LoadItems(String _Filter)
{
AtomLink listFeedLink =
wksItems.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new
ListQuery(listFeedLink.HRef.ToString());
if (!_Filter.Trim().Equals(""))
listQuery.SpreadsheetQuery = "upper([name]) contains
upper('" + _Filter + "')";
lstItems = service.Query(listQuery);
}
Thanks in advance for the help.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
