How to get data in ofbiz data model when just had partyID?

Question

I'm using ofbiz framework and researching data modeling. But I'm confusing with getting data from an entity when just had partyID.

When I know a partyID, I can query at party table to get Party_type_id. Then, I use this Party_type_id to query at party_type to get type of party, example PERSON or PARTY_GROUP. But then how can I exactly go to PERSON or PARTY_GROUP to get individual information of them ? Because I don't show any relationship between party_type and name of table (PERSON or PARTY_GROUP).

You may try this link. It helped me a lot. https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams — Sattam, Jun 22 '16 at 09:26

Senthilmurugan · Answer 1 · 2014-03-01T06:35:20.733

I think viewEntity Can solve your problem.

Add the following view-entity in endityengine.xml.

    <view-entity entity-name="PartyInfo"
                 package-name="org.ofbiz.party"
                 title="View that combines Person, Paryt and PartyGroup">
  <member-entity entity-alias="P" entity-name="Party"/>
  <member-entity entity-alias="PG" entity-name="PartyGroup"/>
  <member-entity entity-alias="PER" entity-name="Person"/>
  <alias entity-alias="P" name="partyId"/>
  <alias entity-alias="PG" name="groupName"/>
  <alias entity-alias="PER" name="firstName"/>
  <alias entity-alias="PER" name="lastName"/>
  <alias entity-alias="P" name="partyTypeId"/>
  <view-link entity-alias="P" rel-entity-alias="PG" rel-optional="true">
    <key-map field-name="partyId"/>
  </view-link>
  <view-link entity-alias="P" rel-entity-alias="PER" rel-optional="true">
    <key-map field-name="partyId"/>
  </view-link>
</view-entity>

which will have the party information including firstName,lastName Or GroupName (if PartyType = 'PARTY_GROUP') and PartyTypeId.

    EntityCondition partyCondition = EntityCondition.makeCondition(UtilMisc.toList(
                    EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, prtyId)), EntityOperator.AND);


    List<GenericValue> partyDetails = delegator.findByCondition("PartyInfo", partyCondition, null, null);

Note : You cannot query databse using this table 'PartyInfo' ( Incase you are not aware of View entity)

Thanks!, in ofbiz I can use entityengine, right, clear. But if I use this data model without framework ofbiz, I can't use data model ? — ThangNguyen, Mar 01 '14 at 10:21

score 0 · Answer 2 · answered Mar 03 '14 at 16:58

0

Use the same party_id to query the table 'person' to get the info of the party of the party_type_id=PERSON

SELECT * FROM PERSON pers, PARTY p WHERE p.PARTY_ID=pers.PARTY_ID AND p.party_type_id='PERSON' AND pers.PARTY_ID='your-party-id'

Use the same party_id to query the table 'person' to get the info of the party of the party_type_id=PARTY_GROUP

SELECT * FROM PARTY_GROUP pg, PARTY p WHERE p.PARTY_ID=pg.PARTY_ID AND p.party_type_id='PARTY_GROUP' AND pg.PARTY_ID='your-party-id'

answered Mar 03 '14 at 16:58

Visa

111
4

Name of table some time not same with party_type_Id ? – ThangNguyen Mar 04 '14 at 01:21
Name of the table will not be same as the party_type_id always. You should know which party – Visa Mar 04 '14 at 08:33
Name of the table will not be same as the party_type_id always. You should know which table to look for that particular party_type_id. – Visa Mar 04 '14 at 08:40

score 0 · Answer 3 · answered Jun 22 '16 at 11:00

0

You may also try to navigate to Application>Framework>EntityEngine and check for the reln for any entity that you want. It gives quite a comprehensive info. Much like the foreign key connects.

answered Jun 22 '16 at 11:00

Sattam

28
4

How to get data in ofbiz data model when just had partyID?

3 Answers3