But where do I apply query overrides? In the SetQuery as follows in a
webpage / JSP:
function init() {
query = new google.visualization.Query(dataSourceUrl);
query.setQuery('select UserName, DiaryEventCode from Diary where
DiaryEventCode = "ADM_11"');
container = document.getElementById("table");
options = {'pageSize': 5};
sendAndDraw();
}
Or in the tableQuerywrapper.js code using:
this.table = new google.visualization.Table(container);
this.query = query;
this.selectQueryClause = 'whatever';
this.sortQueryClause = '';
this.pageQueryClause = '';
this.container = container;
this.currentDataTable = null
On Aug 2, 10:04 am, Badtnik <[email protected]> wrote:
> I see.
> Not sure this'll solve your problem, buy you might want to use a select
> clause in your query.
> See:http://code.google.com/apis/visualization/documentation/querylanguage...
>
> Badtnik
>
>
>
> On Mon, Aug 2, 2010 at 11:09 AM, MartinOShea <[email protected]> wrote:
> > Or do I need to construct a query via the capabilities element of the
> > SQLDataSourceServlet?
>
> > On Aug 2, 7:29 am, Badtnik <[email protected]> wrote:
> > > Hello Martin
>
> > > Did you have a look at the DataView table wrapper?
> >http://code.google.com/apis/visualization/documentation/reference.htm...
>
> > > <http://code.google.com/apis/visualization/documentation/reference.htm..
> > .>
> > > Badtnik
>
> > > On Mon, Aug 2, 2010 at 1:41 AM, MartinOShea <[email protected]>
> > wrote:
> > > > Hello
>
> > > > I've used the Table Query Wrapper Example code at:
>
> > > >http://code.google.com/apis/visualization/docu['default'],
> > mentation/examples.html#tablequerywrapper<
> >http://code.google.com/apis/visualization/documentation/examples.html...>
>
> > > > To retreieve data from a table in a MySQL database by using a URL as
> > > > follows:
>
> > > > var dataSourceUrl ='http://localhost:8080/myApp/SQLDataSource';
>
> > > > And hardcoding the connection parameters in the SQLDataSourceServlet
> > > > provided in the downloadable examples. So, in the servlet, I have
> > > > code:
>
> > > > �...@override
> > > > public DataTable generateDataTable(Query query, HttpServletRequest
> > > > request)
> > > > throws DataSourceException {
> > > > SqlDatabaseDescription dbDescription = new SqlDatabaseDescription(
> > > > "jdbc:mysql://localhost:3306/myApp",
>
> > > > "root", "password","table");
>
> > > > return SqlDataSourceHelper.executeQuery(query, dbDescription);
> > > > }
>
> > > > Rather than taking these values from the parameter string of the URL.
> > > > This works fine and displays the table on the web page. But, it gives
> > > > me all the columns of the targeted table whereas I need to be able to
> > > > display only a subset of the columns.
>
> > > > I can see nowhere where this might be done though; I have added
> > > > parameters to the URL's query string using the tq instruction and have
> > > > tried changing the Javascript in the tablequerywrapper.js file. But
> > > > the result is always the full table.
>
> > > > Can anyone suggest what I might be doing wrong or not doing?
>
> > > > Thanks
>
> > > > Martin O'Shea.
>
> > > > --
> > > > 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]<google-visualization-api%[email protected]>
> > <google-visualization-api%[email protected]<api%252bunsubscri�[email protected]>
>
> > > > .
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/google-visualization-api?hl=en.-Hide
> > quoted text -
>
> > > - Show quoted text -
>
> > --
> > 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]<google-visualization-api%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/google-visualization-api?hl=en.- Hide quoted
> >text -
>
> - Show quoted text -
--
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.
