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%20Charts%20and%20Data/

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*
ludo...@xwiki.com
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>

Reply via email to