You have to query the data source, you can't just pass the URL to the
DataTable constructor. Try this: http://jsfiddle.net/asgallant/2Yxjb/. I
couldn't test this, since the spreadsheet isn't published, so you will have
to test it yourself.
On Thursday, May 2, 2013 11:37:09 AM UTC-4, Melissa wrote:
>
> Hi,
>
> Wondering if you ever found a solution outside of PHP for this?
>
> I've been trying to do the same on an intranet site as well.
>
> Trying to use stringfilter on a datasource, but am unable to get it
> going... :/
>
> ~ Mel
>
> Here's what I've tried.
>
> function drawVisualization() {
> // Prepare the data.
> var data = google.visualization.arrayToDataTable('
> http://spreadsheets.google.com/pub?key=rh_6pF1K_XsruwVr_doofvw<https://docs.google.com/a/trialpay.com/spreadsheet/tq?key=0Aq0JV5YY3yQLdG1kcWtrbWR2NVBCZGR3ZlRpeUk4bXc&gid=1&headers=-1>
> ');
>
> // Define a StringFilter control for the 'Name' column
> var stringFilter = new google.visualization.ControlWrapper({
> 'controlType': 'StringFilter',
> 'containerId': 'control1',
> 'options': {
> 'filterColumnLabel': 'Name'
> }
> });
>
> // Define a table visualization
> var table = new google.visualization.ChartWrapper({
> 'chartType': 'Table',
> 'containerId': 'chart1',
> 'options': {'height': '13em', 'width': '20em'}
> });
>
> // Create the dashboard.
> var dashboard = new google.visualization.Dashboard(document.
> getElementById('dashboard')).
> // Configure the string filter to affect the table contents
> bind(stringFilter, table).
> // Draw the dashboard
> draw(data);
> }
>
> On Saturday, December 4, 2010 10:07:45 PM UTC-8, Johnathon Taylor wrote:
>>
>> Hi,
>>
>> Im really new to google Api's and have very recently started using the
>> visualisation API to display some of my company's reporting on an
>> Intranet page.
>>
>> The problem im having is letting a viewer filter the data using a text
>> input, I using the playground to come up with some great Idea for drop
>> down lists that get us so far but to really make the page useful the
>> user would need to search for certain items
>>
>> I saw that the playground did give the user a chance to query the data
>> using the GQL parameters and that seemed to work fine for me, but I
>> would love to part write the query (say "Where D contains") and let
>> the user just enter the text they want to search on ?
>>
>> Hope this is possible
>>
>> Many Thanks for any help anyone can offer
>
>
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
