Ahh. This may be possible using the Visualization API's controls, depending on what kind of controls you are using. You should be able to make something work with NumberRangeFilters, DateRangeFilters, StringFilters, and ChartRangeFilters. CategoryFilters may be viable as well, depending on how many different categories are in your data set.
To make this sort of thing work, you need to set up a data source on your server that accepts some filtering criteria. If you want to enable server-side paging, you need to accept an index for the record number or page to return results for as well. This data source should return results in the DataTable JSON format (explained in this post<https://groups.google.com/d/msg/google-visualization-api/2LNtd5Fe8L8/QXJHhQBvBHEJ> ). In javascript, create a DataTable that contains the range of numbers, dates, etc that you are filtering on. For StringFilters, this DataTable should have a "string" type column, but the column does not need to have any data in it. For CategoryFilters, this DataTable needs to contain every valid category to filter on. You should query your database to get valid ranges, categories, etc. to populate this DataTable. Create a dummy Table visualization that is drawn inside a hidden div on your page, so the user cannot see it, and create a "ready" event handler for the dummy Table. In the event handler, get the state of each control, and send an AJAX request to your server for the relevant data. In the success callback from the AJAX call, put the data in a new DataTable and draw your real Table using this data. On Friday, May 23, 2014 5:34:10 PM UTC-4, Missy wrote: > > Dear Andrew, > > Thank you so much for your quick and helpful response. I appreciate your > help. I was looking for control property which only render specific row > numbers into my table. > > My current issue is that, I am calling 10,000 lines of data to my > table(using database query) and whenever the page load it freezes. So, I am > trying to look for a method/approach, where I can only display only 100 > rows of data in my table,when the page loads. and being able to filter > the 10,000 data records using controls. > > please advice, if possible. > Thank you so much for your help and time. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
