Hello, I'm having problems with Query Language in Google Visualization API. I'm using the This query: select xtime, page_views limit 200 gets translated to this SQL query: SELECT * FROM mytable LIMIT 200
But this one: select year(xtime), page_views limit 200 gets translated to this SQL query: SELECT * FROM mytable The year function is ignored and so is the limit clause. Is my query syntax incorrect? At the moment I'm working around this problem by using conditions like xtime > date '2010-1-1 00:00:01', but I'd rather be able to use the scalar functions for manipulationg dates.SqlDataSourceHelper from the Data Source Java Library and it works fine, except for scalar functions. This query: select xtime, page_views limit 200 gets translated to this SQL query: SELECT * FROM mytable LIMIT 200 But this one: select year(xtime), page_views limit 200 gets translated to this SQL query: SELECT * FROM mytable The year function is ignored and so is the limit clause. Is my query syntax incorrect? At the moment I'm working around this problem by using conditions like xtime > date '2010-1-1 00:00:01', but I'd rather be able to use the scalar functions for manipulationg dates. -- 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.
