[xwiki-devs] New extensions for querying XWiki data and generating Charts
Hi, I've created a new extension (appwithinminutes-charts) and updated an older one (application-querygenerator). http://extensions.xwiki.org/xwiki/bin/view/Extension/Query%20Generator http://extensions.xwiki.org/xwiki/bin/view/Extension/AppWithin%20Minutes%20C... These extensions allow to query XWiki data in a simpler way for non technical users and help create a macro allowing to display a sub-set of XWiki data as well as a chart to count or sum data. The query generator extension in adding to the "querymacro" now includes a "livetable" macro. This livetable extension wraps the velocity #livetable macro in an XWiki macro. The livetable macro is using a modified version of the AppWithinMinute livetable generator. The query macro supports XWQL and HQL queries and displays the data as HTML tables. The chart macro allows to display a 2 columns aggregation as a table and as a chart. The chart package also includes a small UI to generate a chart of a specific AWM application. The query generator is the most complex code as it allows to create an XWQL or HQL query with restrictions on the different field types (string, date, number, list) and also generate the syntax for the livetable, query and chart macros. It is quite useful to generate the right XWQL and HQL syntax based on the restrictions you want to do. It allows to preview the result in the same screen. The chart package includes french and english translation, however the query generator is not translated at all and the code is not very clean. It includes quite some groovy code to generate the UI and includes the XWQL and HQL query generator. Ludovic -- *Ludovic Dubost* *Founder and CEO* [email protected] skype: ldubost Blog: http://blog.ludovic.orgTry XWiki on the cloud <http://www.xwiki.com/en/products/try-xwiki-cloud> - Try Cryptpad: Secure realtime Wysiwyg Editing <https://cryptpad.fr>
Cool Ludo, thanks for your work. If you want to advertise it even more you could post it on the forum in the new section: https://forum.xwiki.org/c/News Thanks -Vincent
On 12 May 2018, at 19:53, Ludovic Dubost <[email protected]> wrote:
Hi,
I've created a new extension (appwithinminutes-charts) and updated an older one (application-querygenerator).
http://extensions.xwiki.org/xwiki/bin/view/Extension/Query%20Generator http://extensions.xwiki.org/xwiki/bin/view/Extension/AppWithin%20Minutes%20C...
These extensions allow to query XWiki data in a simpler way for non technical users and help create a macro allowing to display a sub-set of XWiki data as well as a chart to count or sum data.
The query generator extension in adding to the "querymacro" now includes a "livetable" macro. This livetable extension wraps the velocity #livetable macro in an XWiki macro. The livetable macro is using a modified version of the AppWithinMinute livetable generator.
The query macro supports XWQL and HQL queries and displays the data as HTML tables.
The chart macro allows to display a 2 columns aggregation as a table and as a chart. The chart package also includes a small UI to generate a chart of a specific AWM application.
The query generator is the most complex code as it allows to create an XWQL or HQL query with restrictions on the different field types (string, date, number, list) and also generate the syntax for the livetable, query and chart macros. It is quite useful to generate the right XWQL and HQL syntax based on the restrictions you want to do. It allows to preview the result in the same screen.
The chart package includes french and english translation, however the query generator is not translated at all and the code is not very clean. It includes quite some groovy code to generate the UI and includes the XWQL and HQL query generator.
Ludovic
-- *Ludovic Dubost* *Founder and CEO* [email protected] skype: ldubost Blog: http://blog.ludovic.orgTry XWiki on the cloud <http://www.xwiki.com/en/products/try-xwiki-cloud> - Try Cryptpad: Secure realtime Wysiwyg Editing <https://cryptpad.fr>
participants (2)
-
Ludovic Dubost -
Vincent Massol