Query Generator and Query Macro

Last modified by Ludovic Dubost on 2018/09/17 00:04

cogGenerates XWQL queries and UI from XClasses
TypeXAR
Developed by

Ludovic Dubost

Active Installs26
Rating
Rate!
0 Votes
LicenseGNU Lesser General Public License 2.1
Installable with the Extension Manager

Description

The Query Generator uses XWiki's core capabilities to generate search forms and a query automatically.
It generates a macro than can be reused in any XWiki page.

The query generator can generate an XWQL query, a query macro and a livetable macro:

querygenerator-livetable.png

The query generator can also generate a chart macro to count documents or sum values grouped by one field:

querygenerator-chart.png

Tested on

This extension has been tested with the following configurations.

Extension VersionXWiki FlavorNotes
1.0XWiki Enterprise 4.5.1
1.1XWiki Enterprise 6.2.1
1.2XWiki Enterprise 9.2

Tested on XWiki version 9.2. It should be compatible with many versions of XWiki.

1.4.1XWiki Enterprise 

Tested on XWiki version 10.2. It should be compatible with many versions of XWiki.

Prerequisites & Installation Instructions

We recommend using the Extension Manager to install this extension (Make sure that the text "Installable with the Extension Manager" is displayed at the top right location on this page to know if this extension can be installed with the Extension Manager). Note that installing Extensions when being offline is currently not supported and you'd need to use some complex manual method.

You can also use the following manual method, which is useful if this extension cannot be installed with the Extension Manager or if you're using an old version of XWiki that doesn't have the Extension Manager:

  1. Log in the wiki with a user having Administration rights
  2. Go to the Administration page and select the Import category
  3. Follow the on-screen instructions to upload the downloaded XAR
  4. Click on the uploaded XAR and follow the instructions
  5. You'll also need to install all dependent Extensions that are not already installed in your wiki

To install the Query Generator and macro install the attached jar

Release Notes

v1.4.1

  • Supports HQL Generation, including sorting
  • Support filters in Chart macro
  • Support number fields
  • Better restrictions support
  • Checking rights in querymacro
  • Bug fixes

v1.4

  • Supports HQL Generation
  • Support filters in Chart macro
  • Support number fields
  • Better restrictions support
  • Bug fixes

v1.3

  • Bug Fixes
  • Add a livetable macro
  • Support generating livetable and awmchart macros

v1.2

New version not requiring QueryPlugin, compatible with more recent version of XWiki.

In query generator, only text and list fields are implemented

Also this new version brings aggregate functions to the query generator and query macro. This allows to sum numbers grouped by other fields.

v1.1

Added alias for the initial unreleased version so it is recognised as the same app.

v1.0

Initial version. 

Tags:
Created by Ludovic Dubost on 2011/08/02 15:47
    

Get Connected