Tuesday 15 June 2010

search - solr - modeling multiple values on 1:n connection -


I try to model my DB using an example from solr wiki.

I have a table named Item and features named with ID, feature name, description

, a table named XML updated here (additional feature name)

  & lt; DataConfig & gt; & Lt; Datasource driver = "org.hsqldb.jdbcDriver" url = "jdbc: hsqldb: / temp / example / pre" user = "sa" /> & Lt; Document & gt; & Lt; Unit name = "item" query = "select from item" & gt; & Lt; Name of the unit = "feature" query = "Description of feature's features, select the feature name, where item_id = '$ {item.ID}' '/> gt; & gt; & gt; & gt; & gt; & lt; / Document & gt;   

Now I get two lists in the XML element

   & lt; arr name = "featurename" & Gt; & lt; str & gt; The universal catalyst was gathering the number of miles in each direction & lt; / str & gt; & gt; & lt; str & gt; Restaurant and things around people and talk things comfortably. Lt; / str> gt; & lt; str & gt; - We have ... - He put his hand to catch cheers - should we & lt; / str & gt; & lt; / ar & gt; & lt; arr name = "description" & gt; & lt; str & gt; a extremist Glowing at the clock for his climax, Max returned to the platform & lt; / str & gt; & lt; str & gt; Air was filled with this and he & lt; / str & gt; & lt ; Str & gt; Here is a party from Janslquair Florian Bridge Club & lt; / str> & lt; / arrival & gt; & lt; / doc & gt;   

But I would like to see the list together (using XML attributes) so that Do not get involved in the values. Is this possible?

I wanted to suggest, it gives you the flexibility to change the data as needed, but this is your case Will not work because it is working

You can always define the aggregation function for string consonants in SQL (), but you are potentially displaying problems.

If you had to use Http / xml data source to resolve flatten atribute.

However, search functionality will work as expected, even if you have a multi-valuable field on the bottom side of the customer where you will add them before the presentation layer, which is not really a problem if you Types of paging are used.

No comments:

Post a Comment