Sorry my last message was not properly formatted and I can't find a
way to edit it. I think my question is how do I use a Query to
"filter" the results for my OrgChart. Without the query paramter /
filter, the OrgChart loads but loads everything, however there are
times when I do not want this behaviour, so I tried this :
chartQuery.setQuery("select * where id = 26");
but the response shown from firebug shows that no rows are returned,
and the chart is not drawn, pls I need help on this.
On Mar 9, 3:53 pm, chalu <chal...@gmail.com> wrote:
> I have been able to make an OrgChart with the GWT Wrappers, and it
> loads well, how ever it loads everything in my database (I implemented
> a datasource) which is not what what I want always. I also want to be
> able to pass parameters to the query so that it can start the OrgChart
> from the matching node instead of always from the ROOT. Here is a
> snippet from my client side (ChartPanel.java) code :
>
> VisualizationUtils.loadVisualizationApi(new Runnable(){
> public void run() {
> chartQuery = Query.create("http://localhost:8080/sungold/
> chartservice");
> setRefreshInterval(refreshInterval);
> // when this line is uncommented, it gets no rows
> chartQuery.setQuery("select * where id = 26");
> chartQuery.send(new Query.Callback() {
>
> public void onResponse(QueryResponse response) {
> unmask();
> if(response.isError()){
> handleQueryError(response);
> }
>
> DataTable data = response.getDataTable();
> OrgChart.Options options =
> OrgChart.Options.create();
> options.setAllowCollapse(true);
> options.setAllowHtml(true);
> options.setSize(OrgChart.Size.SMALL);
> orgChart = new OrgChart(data, options);
> orgChart.addSelectHandler(new SelectHandler()
> {
> @Override
> public void onSelect(SelectEvent event) {
> throw new
> UnsupportedOperationException("Not supported yet.");
> }
> });
> add(orgChart);
> layout(true);
> ready = true;
> //drawChart(data, options);
> }
> });
> }}, OrgChart.PACKAGE);
> }
>
> and then my datasource form the server (RemoteChartService) is thus :
> public DataTable generateDataTable(Query query, HttpServletRequest
> hsr) throws DataSourceException {
> DataTable data = new DataTable();
> ChartNodeDao nodeDao = new ChartNodeDao();
>
> data.addColumn(new ColumnDescription("id", ValueType.TEXT,
> null));
> data.addColumn(new ColumnDescription("upline", ValueType.TEXT,
> null));
> data.addColumn(new ColumnDescription("tip", ValueType.TEXT,
> null));
> //data.addColumn(new ColumnDescription("member",
> ValueType.TEXT, null));
>
> // this returns everything from the database table
> ArrayList<ChartNode> nodeList = (ArrayList<ChartNode>)
> nodeDao.findEntities();
>
> for (ChartNode node : nodeList) {
> String owner = node.getOwner().getFullName();
> String tip = node.getOwner().getFullName() + " " +
> node.getSlot().getTitle();
>
> String uplineVal = "";
> String nodeId = String.valueOf( node.getSlot().getId() );
> Slot upline = node.getUpline();
>
> if(upline != null){
> uplineVal =
> String.valueOf( node.getUpline().getId() );
> }
>
> TableRow row = new TableRow();
> row.addCell( new TableCell(new TextValue(nodeId),
> owner) );
> row.addCell(uplineVal);
> row.addCell(tip);
> data.addRow(row);
> }
>
> return data;
> }
>
> You can see clearly that my datatable defines an id field, which also
> gets populated, but I just cannot query it with something like
> chartQuery.setQuery("select * where id = 26"); Please am I missing
> something ??
> First I'd like to use this query value to pull the data from the
> database, instead of loading hundreds of records that will not be
> used, and then the chart should now have just what it needs to work.
> Any hints on this
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-...@googlegroups.com.
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
