On Wednesday, March 2, 2016 at 3:45:34 PM UTC-8, ivanelson wrote: > > The "Any graph on any page" option [1] "Visualisation" plugin does not > work for me. > > What is wrong with my configuration? > > *[viz.http://mytrac.com/wiki/common/dap_dash >> <http://mytrac.com/wiki/common/dap_dash>]* >> *source =* SELECT t.status, count(t.id) >> FROM ticket t, enum p, ticket_custom c >> WHERE t.id = c.ticket AND c.name = 'setor' >> AND p.name = t.priority AND p.type = 'priority' and c.value='DAP' >> AND t.status <> 'closed' >> group by t.status >> order by case when t.status = 'new' then '0' else t.status end >> *selector =* >> *type =* PieChart >> *options =* pieSliceText: 'value-and-percentage', title: 'Tickets por >> Status', width: 900, height: 500, is3D: 'true' > > > > [1] https://trac-hacks.org/wiki/VisualizationPlugin#Examples >
The source parameter does not accept SQL. According to the documentation: 2. Set its source option to the remote data source url It looks like you should use the URL to a publicly-accessible QueryModule, which could be the local Trac. The query argument can contain query parameters. - Ryan -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
