Hi R.S.,

The deprecated warning is coz of "EntityExpr" you can use "EntityCondition" instead.

About GeoAssocAndGeoTo, rel-optional is not something that would be of help here. and with just the data loaded properly it should show up.

I tried it on demo-stable server and it works for me. you can verify it from
https://demo-stable.ofbiz.apache.org:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo


just in case, if you need steps,
1. goto https://localhost:8443/webtools/control/EntityImport
2. paste the data below and hit 'Import Text button.

    <GeoAssoc geoId="DE" geoIdTo="DE-BW" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-BY" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-BE" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-BR" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-HB" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-HH" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-HE" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-MV" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-NI" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-NW" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-RP" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-SL" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-SH" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-SN" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-SA" geoAssocTypeId="REGIONS"/>
    <GeoAssoc geoId="DE" geoIdTo="DE-TH" geoAssocTypeId="REGIONS"/>

3. verify the data from
https://localhost:8443/webtools/control/FindGeneric?entityName=GeoAssocAndGeoTo

--
Thanks & Regards
Atul Vani
Enterprise Software Developer
HotWax Media Pvt. Ltd.
http://www.hotwaxmedia.com/
We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself.


R. S. wrote:
IMHO the Entity View uses an inner join and that is one of the reasons why all the 16 German states doesn't appear in this view. After I added <GeoAssoc geoId="DE" geoIdTo="DE-BW" geoAssocTypeId="REGIONS"/> (and other 15 states) to the "/framework/common/dataGeoData_DE.xml", rebuild and restart the server, nothing happend in the "GeoAssocAndGeoTo" Entity View. To do an outer join with "rel-optional="true"" brought also nothing. I don't know if it is a bug or my disability :-) Maybe I make something wrong.
The other question is, why I get a deprecated warning after I add this

"EntityCondition.makeCondition("geoTypeId", "STATE"), new EntityExpr("geoId", EntityOperator.LIKE, "DE-%"));"

to CommonWorkers.java

Best Regards,
Rudolf


Atul Vani schrieb:
Hi All,

I wonder if the problem R.S. faced was actually a bug or done so intentionally. If it's a mistake I would like to provide a patch and get it fixed. Please share you opinions.

Reply via email to