No one came across this problem... I think in current implementation it is not possible to simulate these queries...
On Tue, Mar 12, 2013 at 10:29 AM, Deepak Agarwal <[email protected]>wrote: > Anyone... > > > On Tue, Mar 12, 2013 at 1:12 AM, Deepak Agarwal <[email protected]>wrote: > >> Is there a way in ofbiz DynamicViewEntity to simulate following db query : >> >> select ii.inventory_item_id, >> (case when sr.datetime_received > '2012-01-02 00:00:00' then >> sum(quantity_on_hand_total) END) as 12month, >> (case when sr.datetime_received > '2012-10-02 00:00:00' then >> sum(quantity_on_hand_total) END) as 6month, >> (case when sr.datetime_received > '2013-03-02 00:00:00' then >> sum(quantity_on_hand_total) END) as 1month >> from inventory_item ii inner join shipment_receipt sr on >> ii.inventory_item_id=sr.inventory_item_id where >> ii.product_id='017J1VE9PQG0I' >> >> >> -- >> Thanks, >> Deepak Agarwal, >> >> Mobile: +91 9501190044 >> > > > > -- > Thanks, > Deepak Agarwal, > > Mobile: +91 9501190044 > -- Thanks, Deepak Agarwal, Mobile: +91 9501190044
