Hi, I'm setting up a Solr 1.3 server for our existing app, and have an issue
importing.
We have a marketing system and want to make campaigns more searchable. Each
campaign has a number of terms which specify either a fixed or percentage
commission (2 separate fields). In addition each term points to a tracker
that can be of type CLICK, IMPRESSION, etc.
I need each campaign to be a document. Since a campaign can have multiple
terms (with one tracker each) I've setup the fields from terms and tracker
as multivalued. However this just gets me 3 separate lists, and even though
there is a relationship between their elements, I can't be certain that
element 1 in the commissionfixed list goes with element 1 in the type list.
The ideal thing would be to encapsulate each terms with its tracker in some
sort of composite (or at least tokenized) field, and then make that
multi-valued. Is this possible somehow? I've been looking at the
documentation for fieldType without luck.
Here are my simplified schema and data-config files:
<entity name="campaign" pk="id" >
<field column="name"/>
<entity name="terms" pk="id" query="select * from terms where
campaign_id='${campaign.id}'">
<field column="commissionfixed"/>
<field column="commissionpercent"/>
<entity name="tracker" pk="id" query="select type from tracker
where id='${terms.tracker_id}'">
<field column="type"/>
</entity>
</entity>
</entity>
<field name="name" type="text" indexed="true" stored="true"/>
<field name="type" type="text" multiValued="true" indexed="true"
stored="true"/>
<field name="commissionfixed" type="float" multiValued="true"
stored="true"/>
<field name="commissionpercent" type="float" multiValued="true"
stored="true"/>
Thanks.
