Opened 9 years ago

Last modified 9 years ago

#4559 new enhancement

adding a query to retrieve labels

Reported by: tuebernickel@… Owned by: Martin Aspeli
Priority: high Component: GoogleChartPlugin
Severity: major Keywords:
Cc: Trac Release: 0.11



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.


This query turns out this (example) table:

27John Doe

Which should create the attached chart.

Attachments (1)

chart.png (3.7 KB) - added by tuebernickel@… 9 years ago.
example chart

Download all attachments as: .zip

Change History (4)

Changed 9 years ago by tuebernickel@…

Attachment: chart.png added

example chart

comment:1 in reply to:  description Changed 9 years ago by anonymous

  • Call: [[GChart(type="pie", chs="250x100", query="SELECT COUNT(id) AS tickets, owner FROM ticket GROUP BY owner;")]]

comment:2 Changed 9 years ago by anonymous

Mmmm.... I think the plugin supports what you want via the column specifier. However, I can't remember the exact syntax right now. The idea is that you tell the plugin what each column in the result set is - labels, xdata, ydata and so on.

I wish I had more time to update the documentation and do proper release management, but right now, I don't. :-/

comment:3 Changed 9 years ago by Geoff Jacobs

I'd also like to see this ability. I'm trying to graph the number of svn commits per user.

SELECT count(lower(author)) AS "Commits", lower(author) AS "Author" FROM revision group by lower(author) order by count(lower(author)) desc

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain Martin Aspeli.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.