Can you point me to the docs on how to create the additional flat index of
note? Thx for the quick reply. Dave.
Sent from my iPhone
On Nov 9, 2011, at 6:03 AM, "Andre Bois-Crettez" <andre.b...@kelkoo.com> wrote:
> I do not think this is possbile directly out of the box in Solr.
>
> A quick workaround would be to fully denormalize the data, ie instead of
> multivalued notes for a customer, have a completely flat index of
> customer_note.
> Or maybe a custom request handler plugin could actually check that matches
> are for note_id[x], note_date[x], and note_Text[x] ? Not sure if this is
> doable.
>
> Andre
>
> David T. Webb wrote:
>> I have a normalized database schema that I have flattened out to create
>> a Solr schema. My question is with regards to searching the multivalued
>> fields that are correlated from the sub-entity in the DataInputHandler.
>>
>>
>> Example
>>
>> I have 2 tables CUSTOMER and NOTE
>>
>>
>> Customer can have one to many notes.
>>
>>
>> My data-config would look similar to this: (Not exact, just setting up
>> the question) J
>>
>>
>> <entity name="customer" query="select id, name, address, city from
>> customer">
>>
>> <entity name="note" query="Select note_id, note_date, note_text from
>> note where customer_id = ${customer.ID}"/>
>>
>> </entity>
>>
>>
>> My schema would be something like this:
>>
>>
>> <field name="id" type="string" indexed="true" stored="true"
>> required="true" />
>>
>> <field name="name" type="string" indexed="true" stored="true"
>> required="false" />
>>
>> <field name="address" type="string" indexed="true" stored="true"
>> required="false" />
>>
>> <field name="city" type="string" indexed="true" stored="true"
>> required="false" />
>>
>>
>> <field name="note_Id" type="long" indexed="false" stored="true"
>> required="false" multiValued="true" />
>> <field name="note_date" type="date" indexed="true" stored="true"
>> required="false" multiValued="true" />
>>
>> <field name="note_text" type="text_general" indexed="true" stored="true"
>> required="false" multiValued="true" />
>>
>>
>> All is well, indexed and searchable.
>>
>> So, if there are 100 notes per customer at varying dates, how would I
>> query to essentially ask:
>>
>>
>> Give me all the Customers where note_text has "sales" AND the note_date
>> is between Date1 and Date2?
>>
>>
>> The multi-valued data is stored as arrays and the array positions line
>> up property. (i.e. note_id[x], note_date[x], and note_Text[x] represent
>> an actual row that was loaded from the database.
>>
>>
>> Any suggestions on how to accomplish my problem?
>>
>>
>> Thank you!
>>
>>
>> --
>>
>> Sincerely,
>>
>> David Webb
>>
>>
>>
>>
>
> --
> André Bois-Crettez
>
> Search technology, Kelkoo
> http://www.kelkoo.com/
>
