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: [email protected]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
