-----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-----
