Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0010931 | Openbravo ERP | A. Platform | public | 2009-10-11 16:46 | 2009-10-20 08:40 |
|
| Reporter | carbonete | |
| Assigned To | iciordia | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0010931: Querying thru REST more than one Business Object |
| Description | Make 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 Solution | Something like http://localhost:8080/openbravo/ws/dal/<HQL_QUERY> [^] |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  query.PNG (155,946) 2009-10-20 03:02
https://issues.openbravo.com/file_download.php?file_id=1864&type=bug
|
|
| 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 | |