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?



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 - This page was cached on 15 Nov 2018 - 11:56.

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