i had allready read that method in the docs and it doesnt say much. so.. 1. what is the format of (filters) ? does is it the same as the query language?
2. "copy the relevant rows from the original datatable" ...why? i am using a dataview so that the user can control what columns they see. how does this work with .getFilteredRows ? 3. so if i have this "A","B",C" 1,pumpkin pie,sally 2,apple pie,fred 3,soup,fred i want to filter on B with the word "pie" so that i just show rows 1 and 2 is that going to work? On Dec 11, 2:19 am, VizBoy <[email protected]> wrote: > Hi, > > You can filter datatables using dataTable.getFilteredRows(filters) > Look at the documentation for explanation on how to use > ithttp://code.google.com/apis/visualization/documentation/reference.htm... > > You will need to create a new datatable, and copy the relevant rows from the > original datatable to the new one. > > Note that this only allows for filters that are exact matches. For instance, > you can filter the table by saying you want the value in the second column > to be "foo" but you *cannot* filter be saying that some column > *contains*"foo" or that some numeric column's value is smaller than 7, > etc... > > Regards, > VizBoy. > > On Wed, Dec 10, 2008 at 11:48 PM, Region 3 DFG <[email protected]>wrote: > > > > > my visualization is fairly basic, it querys a spreadsheet and returns > > all records. in the vis there is a text input box where i would like > > the user to be able to enter text to filter the resulting table. but > > how do i do this after i have already done query.send ? > > > do i use the FilterDataTableControl ?? it seems a little complex for > > something that sounds simple. > > >http://systemsbiology-visualizations.googlegroups.com/web/FilterDataT... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
