I have this same issue - did you ever find a solution? Would love a solve
for this. Thanks.
On Tuesday, June 30, 2015 at 9:56:57 AM UTC-5, Dutch wrote:
>
> With the new release of the Visualization API and Sheets, when I execute a
> query against a sheet, it doesn't return rows that are filtered in the
> sheet. This is new behavior - previously, all data was returned - filters
> were ignored. I need a way to get back to this behavior - I can't have my
> dataset impacted by filters that sheet users have changed.
>
> I tried to convert our team to user Filter Views (rather than filters) -
> with this approach, users can view filtered data with no impact each other
> or to the Query dataset. The issue with this is that maintaining the
> filters views is cumbersome (I have many and there is no way to sort them)
> and every time a new value is added to the filter column in a view, that
> new value is added to every filter view.
>
> Anyone have a way for me to query and ignore filters?
>
>
> Simple Code Snippet:
>
> var query = new google.visualization.Query(myGoogleSheetURL);
> query.setQuery('select A, B, C');
> query.send(handleQueryResponse);
>
> ...
>
> function handleQueryResponse(response) {
> data = response.getDataTable();
> }
>
--
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 https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/6e4ee326-382f-4b02-990f-a1916f3fe113%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
