Can do you a DB join on OurID? That makes the association in the
database, before it gets to the DataImportHandler.
On Sun, Aug 8, 2010 at 6:17 PM, Frank A <fsa...@gmail.com> wrote:
> Hi,
>
> I have a db handler with the following definition:
>
> <entity name="place"
> query="select OurID,Name,City,State,lat,lng,cost from place"
> deltaQuery="select OurID from destinations where
> OurID= '${dataimporter.request.did}'"
> deltaImportQuery="select
> OurID,Name,City,State,lat,lng,cost from place where
> OurID='${dataimporter.delta.id}'"
> >
>
> <entity name="features"
> query="select label,f.FeatureID from features f,
> featureplace fp where fp.PlaceID='${place.OurID}' and
> fp.FeatureID=f.FeatureID">
> <field name="featureLabel" column="label" />
> <field name="FeatureID" column="FeatureID" />
> </entity>
>
> In my schema I have:
>
> <field name="featureLabel" type="string" indexed="true"
> stored="true" multiValued="true"/>
> <field name="FeatureID" type="string" indexed="true" stored="true"
> multiValued="true"/>
>
> This yields results that have a list of feature labels and a separate
> list of FeatureIDs with now real connection between the two. Is there
> a better way to represent this?
>
> Thanks.
>
--
Lance Norskog
goks...@gmail.com
