OFBiz › OFBiz - Dev

entityModel.xml

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 4 messages Options
Ron Wheeler
Reply | Threaded
Open this post in threaded view
♦
♦
|

entityModel.xml

Ron Wheeler

PostalAddress has   <field name="countryGeoId" type="id"></field>
defined twice.


<entity entity-name="PostalAddress"
             package-name="org.ofbiz.party.contact"
             title="Postal Address Entity">
       <field name="contactMechId" type="id-ne"></field>
       <field name="toName" type="name"></field>
       <field name="attnName" type="name"></field>
       <field name="address1" type="long-varchar"></field>
       <field name="address2" type="long-varchar"></field>
       <field name="directions" type="long-varchar"></field>
       <field name="city" type="name"></field>
       <field name="postalCode" type="short-varchar"></field>
       <field name="postalCodeExt" type="short-varchar"></field>
       <field name="countryGeoId" type="id"></field>
       <field name="stateProvinceGeoId" type="id"></field>
       <field name="countyGeoId" type="id"></field>
       <field name="postalCodeGeoId" type="id"></field>
       <field name="geoPointId" type="id"></field>
       <prim-key field="contactMechId"/>
       <relation type="one" fk-name="POST_ADDR_CMECH"
rel-entity-name="ContactMech">
         <key-map field-name="contactMechId"/>
       </relation>
       <relation type="one" fk-name="POST_ADDR_CGEO" title="Country"
rel-entity-name="Geo">
         <key-map field-name="countryGeoId" rel-field-name="geoId"/>
       </relation>
       <relation type="one" fk-name="POST_ADDR_SPGEO"
title="StateProvince" rel-entity-name="Geo">
         <key-map field-name="stateProvinceGeoId" rel-field-name="geoId"/>
       </relation>
       <relation type="one" fk-name="POST_ADDR_CNTG" title="County"
rel-entity-name="Geo">
         <key-map field-name="countyGeoId" rel-field-name="geoId"/>
       </relation>
       <relation type="one" fk-name="POST_ADDR_PCGEO" title="PostalCode"
rel-entity-name="Geo">
         <key-map field-name="postalCodeGeoId" rel-field-name="geoId"/>
       </relation>
       <relation type="one" fk-name="POST_ADDR_GEOPT"
rel-entity-name="GeoPoint">
         <key-map field-name="geoPointId"/>
       </relation>
       <index name="ADDRESS1_IDX">
         <index-field name="address1"/>
       </index>
       <index name="ADDRESS2_IDX">
         <index-field name="address2"/>
       </index>
       <index name="CITY_IDX">
         <index-field name="city"/>
       </index>
       <index name="POSTAL_CODE_IDX">
         <index-field name="postalCode"/>
       </index>
     </entity>

--
Ron Wheeler
President
Artifact Software Inc
email: [hidden email]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

Nicolas Malin-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: entityModel.xml

Nicolas Malin-2
Ron are you sure ?

I forgot my glasses at home (and yes, I'm not in my home ;) ) but I see
countryGeoId and countyGeoId .

I miss a trivial information ?

Nicolas

Le 13/01/2015 22:11, Ron Wheeler a écrit :

>
> PostalAddress has   <field name="countryGeoId" type="id"></field>
> defined twice.
>
>
> <entity entity-name="PostalAddress"
>             package-name="org.ofbiz.party.contact"
>             title="Postal Address Entity">
>       <field name="contactMechId" type="id-ne"></field>
>       <field name="toName" type="name"></field>
>       <field name="attnName" type="name"></field>
>       <field name="address1" type="long-varchar"></field>
>       <field name="address2" type="long-varchar"></field>
>       <field name="directions" type="long-varchar"></field>
>       <field name="city" type="name"></field>
>       <field name="postalCode" type="short-varchar"></field>
>       <field name="postalCodeExt" type="short-varchar"></field>
>       <field name="countryGeoId" type="id"></field>
>       <field name="stateProvinceGeoId" type="id"></field>
>       <field name="countyGeoId" type="id"></field>
>       <field name="postalCodeGeoId" type="id"></field>
>       <field name="geoPointId" type="id"></field>
>       <prim-key field="contactMechId"/>
>       <relation type="one" fk-name="POST_ADDR_CMECH"
> rel-entity-name="ContactMech">
>         <key-map field-name="contactMechId"/>
>       </relation>
>       <relation type="one" fk-name="POST_ADDR_CGEO" title="Country"
> rel-entity-name="Geo">
>         <key-map field-name="countryGeoId" rel-field-name="geoId"/>
>       </relation>
>       <relation type="one" fk-name="POST_ADDR_SPGEO"
> title="StateProvince" rel-entity-name="Geo">
>         <key-map field-name="stateProvinceGeoId" rel-field-name="geoId"/>
>       </relation>
>       <relation type="one" fk-name="POST_ADDR_CNTG" title="County"
> rel-entity-name="Geo">
>         <key-map field-name="countyGeoId" rel-field-name="geoId"/>
>       </relation>
>       <relation type="one" fk-name="POST_ADDR_PCGEO"
> title="PostalCode" rel-entity-name="Geo">
>         <key-map field-name="postalCodeGeoId" rel-field-name="geoId"/>
>       </relation>
>       <relation type="one" fk-name="POST_ADDR_GEOPT"
> rel-entity-name="GeoPoint">
>         <key-map field-name="geoPointId"/>
>       </relation>
>       <index name="ADDRESS1_IDX">
>         <index-field name="address1"/>
>       </index>
>       <index name="ADDRESS2_IDX">
>         <index-field name="address2"/>
>       </index>
>       <index name="CITY_IDX">
>         <index-field name="city"/>
>       </index>
>       <index name="POSTAL_CODE_IDX">
>         <index-field name="postalCode"/>
>       </index>
>     </entity>
>
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: entityModel.xml

Jacques Le Roux
Administrator
You are right Nicolas, even w/o your glasses :) (just search for countryGeoId, you will see only one)

Jacques

Le 13/01/2015 22:37, Nicolas Malin a écrit :

> Ron are you sure ?
>
> I forgot my glasses at home (and yes, I'm not in my home ;) ) but I see countryGeoId and countyGeoId .
>
> I miss a trivial information ?
>
> Nicolas
>
> Le 13/01/2015 22:11, Ron Wheeler a écrit :
>>
>> PostalAddress has   <field name="countryGeoId" type="id"></field> defined twice.
>>
>>
>> <entity entity-name="PostalAddress"
>>             package-name="org.ofbiz.party.contact"
>>             title="Postal Address Entity">
>>       <field name="contactMechId" type="id-ne"></field>
>>       <field name="toName" type="name"></field>
>>       <field name="attnName" type="name"></field>
>>       <field name="address1" type="long-varchar"></field>
>>       <field name="address2" type="long-varchar"></field>
>>       <field name="directions" type="long-varchar"></field>
>>       <field name="city" type="name"></field>
>>       <field name="postalCode" type="short-varchar"></field>
>>       <field name="postalCodeExt" type="short-varchar"></field>
>>       <field name="countryGeoId" type="id"></field>
>>       <field name="stateProvinceGeoId" type="id"></field>
>>       <field name="countyGeoId" type="id"></field>
>>       <field name="postalCodeGeoId" type="id"></field>
>>       <field name="geoPointId" type="id"></field>
>>       <prim-key field="contactMechId"/>
>>       <relation type="one" fk-name="POST_ADDR_CMECH" rel-entity-name="ContactMech">
>>         <key-map field-name="contactMechId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_CGEO" title="Country" rel-entity-name="Geo">
>>         <key-map field-name="countryGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_SPGEO" title="StateProvince" rel-entity-name="Geo">
>>         <key-map field-name="stateProvinceGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_CNTG" title="County" rel-entity-name="Geo">
>>         <key-map field-name="countyGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_PCGEO" title="PostalCode" rel-entity-name="Geo">
>>         <key-map field-name="postalCodeGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_GEOPT" rel-entity-name="GeoPoint">
>>         <key-map field-name="geoPointId"/>
>>       </relation>
>>       <index name="ADDRESS1_IDX">
>>         <index-field name="address1"/>
>>       </index>
>>       <index name="ADDRESS2_IDX">
>>         <index-field name="address2"/>
>>       </index>
>>       <index name="CITY_IDX">
>>         <index-field name="city"/>
>>       </index>
>>       <index name="POSTAL_CODE_IDX">
>>         <index-field name="postalCode"/>
>>       </index>
>>     </entity>
>>
>
Ron Wheeler
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: entityModel.xml

Ron Wheeler
In reply to this post by Nicolas Malin-2
I think that you have got the better glasses or eyes:-) .

We don't use Counties very much in Canada and my eyes missed the extra "u".

My world has been put right again.

Ron

On 13/01/2015 4:37 PM, Nicolas Malin wrote:

> Ron are you sure ?
>
> I forgot my glasses at home (and yes, I'm not in my home ;) ) but I
> see countryGeoId and countyGeoId .
>
> I miss a trivial information ?
>
> Nicolas
>
> Le 13/01/2015 22:11, Ron Wheeler a écrit :
>>
>> PostalAddress has   <field name="countryGeoId" type="id"></field>
>> defined twice.
>>
>>
>> <entity entity-name="PostalAddress"
>>             package-name="org.ofbiz.party.contact"
>>             title="Postal Address Entity">
>>       <field name="contactMechId" type="id-ne"></field>
>>       <field name="toName" type="name"></field>
>>       <field name="attnName" type="name"></field>
>>       <field name="address1" type="long-varchar"></field>
>>       <field name="address2" type="long-varchar"></field>
>>       <field name="directions" type="long-varchar"></field>
>>       <field name="city" type="name"></field>
>>       <field name="postalCode" type="short-varchar"></field>
>>       <field name="postalCodeExt" type="short-varchar"></field>
>>       <field name="countryGeoId" type="id"></field>
>>       <field name="stateProvinceGeoId" type="id"></field>
>>       <field name="countyGeoId" type="id"></field>
>>       <field name="postalCodeGeoId" type="id"></field>
>>       <field name="geoPointId" type="id"></field>
>>       <prim-key field="contactMechId"/>
>>       <relation type="one" fk-name="POST_ADDR_CMECH"
>> rel-entity-name="ContactMech">
>>         <key-map field-name="contactMechId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_CGEO" title="Country"
>> rel-entity-name="Geo">
>>         <key-map field-name="countryGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_SPGEO"
>> title="StateProvince" rel-entity-name="Geo">
>>         <key-map field-name="stateProvinceGeoId"
>> rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_CNTG" title="County"
>> rel-entity-name="Geo">
>>         <key-map field-name="countyGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_PCGEO"
>> title="PostalCode" rel-entity-name="Geo">
>>         <key-map field-name="postalCodeGeoId" rel-field-name="geoId"/>
>>       </relation>
>>       <relation type="one" fk-name="POST_ADDR_GEOPT"
>> rel-entity-name="GeoPoint">
>>         <key-map field-name="geoPointId"/>
>>       </relation>
>>       <index name="ADDRESS1_IDX">
>>         <index-field name="address1"/>
>>       </index>
>>       <index name="ADDRESS2_IDX">
>>         <index-field name="address2"/>
>>       </index>
>>       <index name="CITY_IDX">
>>         <index-field name="city"/>
>>       </index>
>>       <index name="POSTAL_CODE_IDX">
>>         <index-field name="postalCode"/>
>>       </index>
>>     </entity>
>>
>


--
Ron Wheeler
President
Artifact Software Inc
email: [hidden email]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

Free forum by Nabble Edit this page