View source | View content page | Page history | Printable version   

Projects:Hqlquerytool/User Manual

The Openbravo HQL Query Tool allows you to try a HQL query directly in the Openbravo web interface. This tool is targeted specifically for developers who need to easily try different HQL queries, it is not targeted for end users.

After installing this module the HQL Query Tool can be found in this menu: General Setup > Application. It allows you to query the whole database so this utility is only available to the System Administrator role.


The HQL Query Tool consists of two parts (see the image above):

The HQL Query Tool will show the data in different formats:

The values of reference properties are shown as hyperlinks. Clicking the hyperlink will show the entity using a simple template and the Openbravo webservice implementation. The details of an object itself can also be viewed by clicking on the value of the id property.

Some example queries:

Retrieved from ""

This page has been accessed 5,348 times. This page was last modified on 8 June 2012, at 05:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.