Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010931Openbravo ERPA. Platformpublic2009-10-11 16:462009-10-20 08:40
Reportercarbonete 
Assigned Toiciordia 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010931: Querying thru REST more than one Business Object
DescriptionMake possible to make rest query with HQL not only in search.
For example to made a query like this :

select S.Name as Regiao,
       U.Name as Vendedor,
       P.Name as Produto,
       C.Name as Categoria,
       L.QtyInvoiced as Qtd,
       L.LineNetAmt as Valor_TOTAL
From
 C_Invoice as I ,
 C_Invoiceline as L ,
 M_Product as P ,
 M_Product_Category as C,
 AD_user as U,
 C_SalesRegion as S
where
 I.IsSOTrx = 'Y' and
 I.ad_client_id = '1000000' and
 I.ad_org_id = '1000000' and
 L.C_Invoice_ID = I.C_Invoice_ID and
 P.M_Product_ID = L.M_Product_ID and
 C.M_Product_Category_ID = P.M_Product_Category_ID and
 U.AD_user_ID = I.SalesRep_ID and
 S.SalesRep_ID = U.AD_user_ID
Steps To Reproduce
Proposed SolutionSomething like http://localhost:8080/openbravo/ws/dal/<HQL_QUERY> [^]
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng query.PNG (155,946) 2009-10-20 03:02
https://issues.openbravo.com/file_download.php?file_id=1864&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-10-11 16:46carboneteNew Issue
2009-10-11 16:46carboneteAssigned To => rafaroda
2009-10-19 08:33rafarodaAssigned Torafaroda => iciordia
2009-10-19 09:31iciordiaNote Added: 0021148
2009-10-20 03:01carboneteNote Added: 0021192
2009-10-20 03:02carboneteFile Added: query.PNG
2009-10-20 08:40iciordiaNote Added: 0021196

Notes
(0021148)
iciordia   
2009-10-19 09:31   
Please, have a look to this module:

http://forge.openbravo.com/plugins/mwiki/index.php/Hqlquerytool/User_Manual [^]

This is a preliminar version but I guess is what you are looking for
(0021192)
carbonete   
2009-10-20 03:01   
My system don´t show windows like in manual.
I attached my window.

But this utlity is not callable by client in REST manner, correct ?

thanks
(0021196)
iciordia   
2009-10-20 08:40   
Can you please post your issue in the module tracker?

This utility is no callable by client in REST manner now, but this is a natural next step in this module. Can you please report it as feature request in the module tracker?

Thanks!

Ismael