The whole point of the QueryWrapper is that we don't want to query the data
source for all the rows as there might be too many rows to handle in the
client.
There is no way to extract the global number of rows when using the query
wrapper as each query requests only for the specific rows in the current
page.
If you know the data is not too large to clog your client and you want to
know up front the total number of rows: you can send another query without
using the query wrapper. If you want to make it small ask for only a single
column (e.g. select A) and you may even choose to make it smaller by
removing the formatted values from each cell (see here:
http://code.google.com/apis/visualization/documentation/querylanguage.html#Options
)
Query('http:
spreadsheets.google.com/tq?key=ABC&tq=select+A+options+no_format');
HTH
ChartMan
On Mon, Nov 29, 2010 at 10:44 PM, Beedrew <[email protected]> wrote:
> Hi,
>
> I'm using a Google spreadsheet (large) as the data source for a
> table. Google's "Table Query Wrapper Example" (http://code.google.com/
> apis/visualization/documentation/examples.html#querywrapper) does
> nearly everything that I need, and I like the fact that the results
> are "paged" so a response comes back fast even if the spreadsheet has
> many rows.
>
> However, I was wondering if there is a way to report to the user the
> size of the total result set? Or another way to say it might be, how
> many pages of results there are.
>
> I tried plugging in this.currentDataTable.getNumberOfRows(), but it
> just returns how many rows are in the page currently displayed, NOT
> the whole result set.
>
> Thanks,
>
> Bee
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Visualization API" group.
> To post to this group, send email to
> [email protected].
> To unsubscribe from this group, send email to
> [email protected]<google-visualization-api%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-visualization-api?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" 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-visualization-api?hl=en.
