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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
