adding a query to retrieve labels
|Reported by:||tuebernickel@…||Owned by:||optilude|
In order to retrieve the data, currently the paramter "query" (transformed into chd) is used, but this does not take any reference to the label.
The "query" parameter should be allowed to return two columns in its result set and forwarding the first one to chd and the second to chdl, so they are associated by the SQL query itself.
- Query: SELECT COUNT(id) AS tickets, owner FROM ticket GROUP BY owner;
- Call: GChart(type="pie", chs="250x100", query="SELECT COUNT(id) AS tickets, owner FROM ticket GROUP BY owner;")?
This query turns out this (example) table:
Which should create the attached chart.