Thanks Noble, that worked beautifully.
What wasn't initially apparent to me was that a transformer can use the same
notation as in the query attribute (e.g. ${parententityname.fieldname} ) to
access fields from parent entities, which allows them to merge data from
multiple related rows, not just different columns.
-Mauricio
On Mon, Nov 10, 2008 at 8:27 PM, Noble Paul നോബിള് नोब्ळ् <
[EMAIL PROTECTED]> wrote:
> 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
>
