code-google-com / google-gdata

Automatically exported from code.google.com/p/google-gdata
0 stars 0 forks source link

ListQuery colheader = number greater than 15 digits Query Does not return filtered Row - Even No Error thrown. #665

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Column header of one of the shpreadsheets columns that needs to be queried is 
photoid.

Photo id is greater than 15 digits. ex:  5890347427860828482

when we use the ListQuery it works well till 15 digits but beyond that it does 
not filter records based on query. 
No Error is thrown.

If we prepend it with a character say like    a5890347427860828482 then query 
filters correctly but not if all digits are numeric.
----------------------------Worksheet-------------------------------------
photoid                             photodescription
5890347427860828482                 first_Photograph_that_fails
5890347427860828483                 second Photograph_that_fails
a5890347427860828482                trial_Photograph_that_pass
----------------------------Code -------------------------------------
 WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
 AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
 ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
 listQuery.SpreadsheetQuery = "photoid = 5890347427860828482"; 
 ListFeed listFeed = service.Query(listQuery);

        foreach (ListEntry row in listFeed.Entries)
        {
            // Print the first column's cell value
         Response.Write("<br><b>"+row.Title.Text+"::&nbsp;&nbsp;</b>");
            // Iterate over the remaining columns, and print each cell 
            foreach (ListEntry.Custom element in row.Elements)
            {
               Response.Write(element.Value + ",");
            }
        }
----------------------------Code Ends-------------------------------------

Original issue reported on code.google.com by DynamicC...@gmail.com on 26 Jun 2013 at 5:40

GoogleCodeExporter commented 9 years ago
Sorry - dint mention the issue in prescribed format, Here's it 

What steps will reproduce the problem?
  See the worksheet sample and code Below.
  I am querying a worksheet (using ListFeed)
Expected Output, What do you see instead ::
  Row must get filtered, Nothing is returned.
Please use labels and text to provide additional information.
  Please see the code and worksheet sample above

Original comment by DynamicC...@gmail.com on 26 Jun 2013 at 5:48