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.