hi , i am trying to work on nested documents in solr 6.2.1. I am trying to generate employee info from database.
parent node consists of empid,cid,sid,pid. child node consists of price,empid,cid,sid,pid.[multiple prices will be exists, remaining values are same as parent] data-config.xml --------------- <entity name="employee" query="select empid,cid,sid,pid from xxxxxxxxxxxxxxxxxxx;"> <field column="empid" name="empid" /> <field column="cid" name="cid" /> <field column="pid" name="pid" /> <entity child="true" name = "basicinfo" query="SELECT price,empid,cid,sid,pid from xxxxxxxx where empid = '${employee.empid}'; " > <field column="empid" name="empid" /> <field column="cid" name="cid" /> <field column="pid" name="pid" /> <field column="price" name="price" /> </entity> </entity> managed-schema -------------- <field name="_root_" type="string" indexed="true" stored="true" multiValued="true" required="false"/> <field name="empid" type="imi_string" indexed="true" required="false" stored="true"/> <field name="sid" type="imi_string" indexed="true" stored="true" default="0"/> <field name="price" type="imi_string" indexed="true" stored="true" default="0"/> <field name="cid" type="imi_string" indexed="true" required="false" stored="true"/> <field name="pid" type="imi_string" indexed="true" required="false" stored="true"/> <uniqueKey>empid</uniqueKey> Did full-import, completed successfully. when i used select query, below resonse got. http://localhost:9119/solr/employee/select?q=*:* { "responseHeader": { "status": 0, "QTime": 0, "params": { "q": "*:*", "indent": "on", "rows": "100", "wt": "json", "_": "1496057171982" } }, "response": { "numFound": 3, "start": 0, "docs": [{ "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "123" }, { "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "567" }, { "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "0" } ] } } when i query above, got the childs along with parent.[parent node that is which is having price 'zero']. I don't know how to write the solr query to get the below response. { "responseHeader": { "status": 0, "QTime": 0, "params": { "q": "*:*", "indent": "on", "rows": "100", "wt": "json", "_": "1496057171982" } }, "response": { "numFound": 3, "start": 0, "docs": [{ "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "0", "_childDocuments_": [{ "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "123" }, { "empid": "E1", "cid": "c1", "sid": "s1", "pid": "p1", "price": "567" } ] }] } } Please help me in this. Many thanks in advance. -- View this message in context: http://lucene.472066.n3.nabble.com/Nested-documents-using-solr-6-2-1-tp4338024.html Sent from the Solr - User mailing list archive at Nabble.com.