Thanks Mikhail verbose did help. _root_ field was missing in schema also in
make some changes in child entity. Like i created id as alias to emp_id ( in
child query) which is id column of parent table.
<entity name="parent" pk="id" datasource="ds-1" query="SELECT
id,name
FROM emp">
<field column="id" name="id" />
<field column="name" name="name" />
<entity child='true' name="child"
query="SELECT dept,emp_id as id
FROM emp_details where emp_id='${parent.id}' ">
<field column="dept"
name="dept" />
</entity>
</entity>
Data seems to be returning correctly as below. but it show child documents
and parent documents are shown as individual document. i was expecting 2
documents and 2 child document for each doc.
Any inputs will be helpful
"response":{"numFound":6,"start":0,"docs":[
{
"dept":"IT",
"id":"1",
"_version_":1608073809653399552},
{
"dept":"Data",
"id":"1",
"_version_":1608073809653399552},
{
"name":"omkar",
"id":"1",
"_version_":1608073809653399552},
{
"dept":"ITI",
"id":"2",
"_version_":1608073809667031040},
{
"dept":"Entry",
"id":"2",
"_version_":1608073809667031040},
{
"name":"ashwin",
"id":"2",
"_version_":1608073809667031040}]
}}
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
