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
-~----------~----~----~----~------~----~------~--~---
