Following entity defintion:
<entity name="mission" dataSource="mssqlDatasource" pk="id"
transformer="TemplateTransformer,
ClobTransformer"
query="SELECT m.id, m.notes,
m.missionFocus,m.start_time,
mar.id AS market, mar.name AS marketName
FROM mission m
INNER JOIN market mar ON m.market = mar.id">
<field column="start_time" name="startTime" />
<field column="market" name="market" />
<field column="marketName" name="marketName"
clob="true" />
<field column="tableType" template="MISSION" />
<entity name="comment" dataSource="mssqlDatasource"
transformer="ClobTransformer"
query="SELECT c.message
FROM comment c
WHERE c.source_id = '${mission.id}'
AND c.source_type = 'mission'">
<field name="commentMessage" column="message" clob="true" />
</entity>
<entity name="activity" dataSource="mssqlDatasource"
query="SELECT a.notes
FROM activity a
WHERE a.mission = '${mission.id}'">
<field name="activityNotes" column="notes" />
</entity>
<entity name="location" dataSource="mssqlDatasource"
query="SELECT l.name
FROM location l
WHERE l.id =
'${activity.id}'">
<field name="locationName" column="name" />
</entity>
</entity>
You see my problem is that the nested entity 'activity' need to return 2
fields namely 'activityNotes' and a field from a nested entity 'location'
namely 'locationName'. How can I realize that? Both fields should be
indexed.. Only chance to COALESCE both strings?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-nested-entity-need-to-return-two-fields-tp4013701.html
Sent from the Solr - User mailing list archive at Nabble.com.
