Thanks David, for explanation, clarification. Kind Regards -- Pranay Pandey
On Mar 23, 2009, at 10:01 PM, David E Jones wrote:
Is it feasible? That depends on the constraints you're working with.It does usually work and can be done, but also often results in asking the database to do more than your code really needs it to do (ie including things in the joins that you don't need, significantly slowing performance). The same is true of poorly defined view- entities with normal (non-view) member entities, but there is more of a tendency for that with views of views.-David On Mar 23, 2009, at 5:36 AM, Pranay Pandey wrote:BJ,Here I am posting my question again for reference from my first email:Please help me in understanding that is it feasible to use one view entity as a member entity into another view entity?Thanks & Regards -- Pranay Pandey On Mar 23, 2009, at 4:51 PM, 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 createdand log I got while fetching records. <view-entity entity-name="OrderItemAndFacilityLocation"package-name="org.ofbiz.product.facility" title="Order Item And FacilityLocation 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 ASPFL_PRODUCT_ID, PFL.FACILITY_ID AS PFL_FACILITY_ID, PFL.LOCATION_SEQ_IDAS 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 ASFL_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_LOCATIONPFL 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 viewentity as a member entity into another view entity? I have tried to do so and saw the log for prepared statement inSQLProcessor.java. Found that there are so many inner joins in thequery 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-----
smime.p7s
Description: S/MIME cryptographic signature