Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010931
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2009-10-11 16:462009-10-20 08:40
ReportercarboneteView Statuspublic 
Assigned Toiciordia 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010931: 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
Proposed SolutionSomething like http://localhost:8080/openbravo/ws/dal/<HQL_QUERY> [^]
TagsNo tags attached.
Attached Filespng file icon query.PNG [^] (155,946 bytes) 2009-10-20 03:02

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0021148)
iciordia (manager)
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 (reporter)
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 (manager)
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

- Issue History
Date Modified Username Field Change
2009-10-11 16:46 carbonete New Issue
2009-10-11 16:46 carbonete Assigned To => rafaroda
2009-10-19 08:33 rafaroda Assigned To rafaroda => iciordia
2009-10-19 09:31 iciordia Note Added: 0021148
2009-10-20 03:01 carbonete Note Added: 0021192
2009-10-20 03:02 carbonete File Added: query.PNG
2009-10-20 08:40 iciordia Note Added: 0021196

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker