Great idea! On Wed, Oct 7, 2009 at 10:18 AM, Martin Taal <[email protected]> wrote: > 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 >
-- -- Víctor Martínez [email protected] ------------------------------------------------------------------------------ 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
