well the whole point of my app is to let the user control what columns they see so filtering (as things stand right now from what you said) seems like a pain. here is my app and if anyone gets a chance to look at it and see a way to make filtering happen i would appreciate it. i have the form field, button, list of fields to let the user select which to filter on, and a function to do the deed with. ...
http://imaps.dfg.ca.gov/viewers/jsapi/region3/reg3-browse-columns.html On Dec 14, 6:45 am, VizBoy <[email protected]> wrote: > Hi, > See comments inline. > > On Thu, Dec 11, 2008 at 8:10 PM, Region 3 DFG <[email protected]> wrote: > > > > > i had allready read that method in the docs and it doesnt say much. > > I agree with you the documentation can be made a bit clearer. We will take > care of that. > > > > > so.. > > > 1. what is the format of (filters) ? does is it the same as the query > > language? > > It is not related to the query language filters at all. > The query language filters support complex filters with logical combinations > (AND, OR, ...) and with order comparisons (<, >, <=, >=, ...). > In this case, the filter is very simple. > Quoting from the docs, an array of objects, each containing a 'column' > property and a 'value' property. > For instance the filter: [{'column': 2, 'value': 7}, {'column': 4, 'value': > 'foo'}] > will match all rows that have the *exact* value 7 in their third column, and > the *exact* value 'foo' in their fifth column. > > > > > 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 ? > > Currently we do not support filtered views. Currently a DataView can only > change the *columns* that you see, and not anything about the rows. > So, if you want to use getFilteredRows, you probably would want to copy the > rows to a new DataTable. > > > > > 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? > > Yes, in this case, use dataTable.getFilteredRows([{'column': 1, 'value': > 'pie'}]); > > Hope this helps, > VizBoy. > > > > > 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 -~----------~----~----~----~------~----~------~--~---
