Looking at very first mail will help to understand the question.
Thanks
Divesh
BJ Freeman wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
What seems to be the problem
what is not working
Pranay Pandey sent the following on 3/23/2009 3:45 AM:
Here for reference I am posting the view entity which has been created
and log I got while fetching records.
<view-entity entity-name="OrderItemAndFacilityLocation"
package-name="org.ofbiz.product.facility" title="Order Item And Facility
Location View Entity">
<member-entity entity-alias="SMT" entity-name="ShipmentMethodType"/>
<member-entity entity-alias="OISG" entity-name="OrderItemShipGroup"/>
<member-entity entity-alias="OI" entity-name="OrderItem"/>
<member-entity entity-alias="PFLV"
entity-name="ProductFacilityLocationView"/>
<alias entity-alias="OISG" name="orderId"/>
<alias entity-alias="OISG" name="shipGroupSeqId"/>
<alias entity-alias="OISG" name="shipmentMethodTypeId"/>
<alias entity-alias="OISG" name="carrierPartyId"/>
<alias entity-alias="OI" name="productId"/>
<alias entity-alias="OI" name="orderItemSeqId"/>
<alias entity-alias="PFLV" name="locationSeqId"/>
<alias entity-alias="PFLV" name="locationTypeEnumId"/>
<view-link entity-alias="PFLV" rel-entity-alias="OI">
<key-map field-name="productId"/>
</view-link>
<view-link entity-alias="OI" rel-entity-alias="OISG">
<key-map field-name="orderId"/>
</view-link>
<view-link entity-alias="OISG" rel-entity-alias="SMT">
<key-map field-name="shipmentMethodTypeId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ShipmentMethodType">
<key-map field-name="shipmentMethodTypeId"/>
</relation>
</view-entity>
and log:
============================
SELECT OISG.ORDER_ID, OISG.SHIP_GROUP_SEQ_ID,
OISG.SHIPMENT_METHOD_TYPE_ID, OISG.CARRIER_PARTY_ID, OI.PRODUCT_ID,
OI.ORDER_ITEM_SEQ_ID, PFLV.PFL_LOCATION_SEQ_ID,
PFLV.FL_LOCATION_TYPE_ENUM_ID FROM (((SELECT PFL.PRODUCT_ID AS
PFL_PRODUCT_ID, PFL.FACILITY_ID AS PFL_FACILITY_ID, PFL.LOCATION_SEQ_ID
AS PFL_LOCATION_SEQ_ID, PFL.MINIMUM_STOCK AS PFL_MINIMUM_STOCK,
PFL.MOVE_QUANTITY AS PFL_MOVE_QUANTITY, FL.LOCATION_TYPE_ENUM_ID AS
FL_LOCATION_TYPE_ENUM_ID, FL.AREA_ID AS FL_AREA_ID, FL.AISLE_ID AS
FL_AISLE_ID, FL.SECTION_ID AS FL_SECTION_ID, FL.LEVEL_ID AS FL_LEVEL_ID,
FL.POSITION_ID AS FL_POSITION_ID FROM OFBIZ.PRODUCT_FACILITY_LOCATION
PFL INNER JOIN OFBIZ.FACILITY_LOCATION FL ON PFL.FACILITY_ID =
FL.FACILITY_ID AND PFL.LOCATION_SEQ_ID = FL.LOCATION_SEQ_ID) PFLV INNER
JOIN OFBIZ.ORDER_ITEM OI ON PFLV.PFL_PRODUCT_ID = OI.PRODUCT_ID) INNER
JOIN OFBIZ.ORDER_ITEM_SHIP_GROUP OISG ON OI.ORDER_ID = OISG.ORDER_ID)
INNER JOIN OFBIZ.SHIPMENT_METHOD_TYPE SMT ON
OISG.SHIPMENT_METHOD_TYPE_ID = SMT.SHIPMENT_METHOD_TYPE_ID WHERE
(OISG.ORDER_ID = ? AND PFLV.FL_LOCATION_TYPE_ENUM_ID = ? AND
OI.ORDER_ITEM_SEQ_ID = ?) ORDER BY OI.ORDER_ITEM_SEQ_ID ASC
=============================
Thanks & Regards
--
Pranay Pandey
On Mar 23, 2009, at 3:51 PM, Pranay Pandey wrote:
Hello All,
Please help me in understanding that is it feasible to use one view
entity as a member entity into another view entity?
I have tried to do so and saw the log for prepared statement in
SQLProcessor.java. Found that there are so many inner joins in the
query on console.
Thanks in advance for any help.
Regards
--
Pranay Pandey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJx3DNrP3NbaWWqE4RAoz6AJ9BNX4Y0PQRd90kWGv1KoGQSalAGwCcDt7Z
CVCddvLEPo2pt3rGy1S5j64=
=02uo
-----END PGP SIGNATURE-----
