Both would work, depends what better fits your requirement.
Badtnik
On Mon, Aug 2, 2010 at 12:11 PM, MartinOShea <[email protected]> wrote:
> 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%[email protected]>
> >
> > > <google-visualization-api%[email protected]<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]>
> <google-visualization-api%[email protected]<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]<google-visualization-api%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-visualization-api?hl=en.
>
>
--
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.
