create a separate field commissionfixed_type and use a
TemplateTransformer to merge two values in the entity 'tracker'
On Tue, Nov 11, 2008 at 1:23 AM, Mauricio Aristizabal <[EMAIL PROTECTED]> wrote:
> 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.
>
--
--Noble Paul
