How to implement sql as below with view-entity definition. select PRODUCT_ID,FACILITY_ID,LOCATION_SEQ_ID, SUM(case when LOCATION_SEQ_ID='A' then QUANTITY_OH_HAND_TOTAL else 0 end) AS QTY1, SUM(case when LOCATION_SEQ_ID='b' then QUANTITY_OH_HAND_TOTAL else 0 end) AS QTY2 from inventory_item where PRODUCT_ID in (select PRODUCT_ID from Product where PRODUCT_TYPE_ID='FINISHED_GOOD') GROUP BY PRODUCT_ID,LOCATION_SEQ_ID
-- View this message in context: http://ofbiz.135035.n4.nabble.com/about-view-entity-tp3546616p3546616.html Sent from the OFBiz - User mailing list archive at Nabble.com.
