Thanks for the response!
Its a bad news that it isnt that simple I hoped.
Certainly I need names and a timestamp for the comment. There are any
problems if I want to add a timestamp in the one long string? Apart from
this can I add this one long string to the index?
Example:
table blog: id, author(foreign key: I want to join table user to get the
firstname and lastname),
title (need to be in the index!), message (need to be in the
index), created (need to be in the index)
table comment: id(int), author(foreign key: I want to join table user to get
the firstname and lastname),
message(need to be in the index), created(timestamp)
result should be:
<doc>
<str name="id">1</str>
<str name="authorFirstName">Jaime</str>
<str name="authofLastName">Oliver</str>
<str name="blogTitle">titleof blog 1</str>
<str name="blogMessage">message of blog 1</str>
<str name="created">2007-11-09 T 11:10</str>
<str name="comment">id|Walter|White|message of comment|2007-11-09
T 11:20</str>
</doc>
I really can do this with RegexTransformer? Can you give me a hint how that
should looks like (my regex is really bad)?
Would be following another choice:
I add all Blogs and after that adding Blogs with Comments and making the
blog entries not to be in index.
Would result following:
<doc>
<str name="id">1</str>
<str name="authorFirstName">Jaime</str>
<str name="authofLastName">Oliver</str>
<str name="blogTitle">titleof blog 1</str>
<str name="blogMessage">message of blog 1</str>
<str name="created">2007-11-09 T 11:10</str>
</doc>
<doc>
<str name="id">1</str>
<str name="authorFirstName">Walter</str>
<str name="authofLastName">White</str>
<str name="commentMessage">message of comment</str>
<str name="created">2007-11-09 T 11:20</str>
</doc>
So I can get blog as results and comments(containing blog values). Its just
important that the blog values in comment are not in the index - so I dont
get blog result twice.
Whats your opinion?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-nested-entity-with-multiple-values-tp4013533p4013602.html
Sent from the Solr - User mailing list archive at Nabble.com.
