New extensions for querying XWiki data and generating Charts

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

New extensions for querying XWiki data and generating Charts

Ludovic Dubost
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*
[hidden email]
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 | Threaded
Open this post in threaded view
|

Re: New extensions for querying XWiki data and generating Charts

vmassol
Administrator
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 <[hidden email]> 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%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*
> [hidden email]
> 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>