Stefen, as u can see
<entity name="torder" query="select
UID_PK,creationDate,email,confirmationCode from torder ">
<field column="creationDate" name="date" />
<entity name="torderattribute"
transformer="TemplateTransformer" query="select UID_PK from torderattribute
where orderUID='${torder.UID_PK}'">
<field column="UID_PK"
<h3>template="{torder.UID_PK},${torderattribute.UID_PK}
" />
</entity>
</entity>
orderUID is a foreignkey for the table torderattribue which maps to
UID_PK(pk) of torder.
when i run the query "select UID_PK from torderattribute where
orderUID='${torder.UID_PK}'" this should fetch multiple rows ,because
corredponding to one orderUID there are multiple rows.
but it is not.
to make it more clear consider this:
torder:
UID_PK(primary key)
120
121
122
torderattribute
UID_PK(primary key) orderUID
86 120
87 120
89 121
90 121
91 121
and in my search result i got only(120,86),(121,89). i am missing 3 values
in torderattribute. why so , please explain.
Thanks
Romi.
-----
Romi
--
View this message in context:
http://lucene.472066.n3.nabble.com/UniqueKey-field-in-schema-xml-tp2987807p2988774.html
Sent from the Solr - User mailing list archive at Nabble.com.
