One view entity member of another view entity
Locked
One view entity member of another view entity
 
|
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 |
smime.p7s (3K)
Re: One view entity member of another view entity
|
|
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 > > > |
Re: One view entity member of another view entity
|
|
Re: One view entity member of another view entity
|
|
Re: One view entity member of another view entity
|
|
In reply to this post by BJ Freeman
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 >> 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----- |
Re: One view entity member of another view entity
|
|
Re: One view entity member of another view entity
|
|
Re: One view entity member of another view entity
|
|
Re: One view entity member of another view entity
|
|
In reply to this post by David E Jones-3
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 >>>> 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----- >> > |
| Free forum by Nabble | Edit this page |