This question about Using an extension: Answered

ChartPlugin with tables generated by DatabasePlugin/SqlPlugin? Any chance?

Hi, is there any way to create a graphical output of data generated by sql plugins? I use databaseplugin to render a table with some actual data stored in db and it would be nice to have an option to draw some kind of progress graphically. Is that possible?

Thanks

Jindrich

Answering myself:

You need to put DATABASE_SQL macro inside EXPAND macro and set the scope to current topic. Works somehow like eval in bash. You need to 'escape' all the % with $percent and " with $quot. Looks like this:
%EXPAND{"$percentDATABASE_SQL{description=$quotsomequery$quot sql=$quotSELECT * FROM sometable;$quot}$percent" scope="CurrentWikiPageName"}%

QuestionForm edit

Subject Using an extension
Extension ChartPlugin
Version Foswiki 1.1.6
Status Answered
Related Topics
Topic revision: r2 - 12 Nov 2014, JindrichHomola
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy