Hi, For your info, I have created a new module which makes it possible to enter/try HQL queries through the Openbravo application itself (in the web browser). It is handy when you want to quickly try out different HQL queries. All Hibernate queries should be supported.
The module is called HQLQueryTool and is available under that name in the CR and Forge. Here is the user manual: http://forge.openbravo.com/plugins/mwiki/index.php/Hqlquerytool/User_Manual After installing the module, the tool can be found in the menu: General Setup > Application Some remarks: - Only System Administrator can use this tool as it allows to query accross clients/orgs and in the ADUser table. - The tool has an extra feature (on the right) to view entities and property names which you can use in the HQL. Here are some sample queries to try out: select sum(listPrice), avg(lineNetAmount) from OrderLine From Order select ol.salesOrder, ol.product From OrderLine ol where ol.product.id='1000006' select ol.product.id, sum(ol.listPrice), count(*) From OrderLine ol group by ol.product.id It is a first version of the tool so let me know if you see nice additions or other improvements. -- With Regards, Martin Taal Openbravo M: +31 6 288 48 943 @: [email protected] Skype: martintaal Openbravo Headquarters: P: +34 93 27 25 947 F: +34 93 27 25 905 Address: Edificio Slan, Planta 2a, Landaben, Calle J, 31012 Pamplona, Navarra, Spain Mailing address: PO Box 5117, 31010 Pamplona, Navarra, Spain ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Openbravo-development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-development
