Hello Team,

Can someone please help to index the below sample json document into Solr.

I have following queries on indexing multi level child document.


  1.  Can we specify names to documents hierarchy such as "therapeuticareas" or 
"sites" while indexing.
  2.  How can we index document at multi-level hierarchy.

I have following queries on retrieving the result.


  1.  How can I retrieve result with full nested structure.

[{
               "id": "NCT00000102",
               "title": "Congenital Adrenal Hyperplasia: Calcium Channels as 
Therapeutic Targets",
               "phase": "Phase 1/Phase 2",
               "status": "Completed",
               "studytype": "Interventional",
               "enrollmenttype": "",
               "sponsorname": ["National Center for Research Resources (NCRR)"],
               "sponsorrole": ["lead"],
               "score": [0],
               "source": "National Center for Research Resources (NCRR)",
               "therapeuticareas": [{
                                             "taid": "ta1",
                                             "ta": "Lung Cancer",
                                             "diseaseAreas": ["Oncology, 
Respiratory tract diseases"],
                                             "pubmeds": [{
                                                            "pmbid": "pm1",
                                                            "articleTitle": 
"Consensus minimum data set for lung cancer multidisciplinary teams Results of 
a Delphi process",
                                                            "revisedDate": 
"2018-12-11T18:30:00Z"
                                             }],
                                             "conferences": [{
                                                            "confid": "conf1",
                                                            "conferencename": 
"American Academy of Neurology Annual Meeting",
                                                            "conferencetopic": 
"Avances en el manejo de los trastornos del movimiento hipercineticos",
                                                            "conferencedate": 
"2019-05-08T18:30:00Z"
                                             }]
                              },
                              {
                                             "taid": "ta2",
                                             "ta": "Breast Cancer",
                                             "diseaseAreas": ["Oncology"],
                                             "pubmeds": [],
                                             "conferences": []
                              }
               ],

               "sites": [{
                              "siteid": "site1",
                              "type": "Hospital",
                              "institutionname": "Methodist Health System",
                              "country": "United States",
                              "state": "Texas",
                              "city": "Dallas",
                              "zip": ""
               }],

               "investigators": [{
                              "invid": "inv1",
                              "investigatorname": "Bryan A Faller",
                              "role": "Principal Investigator",
                              "location": "",
                              "score": ""
               }],

               "Drugs": [{
                              "id": "11",
                              "drugname": "Methotrexate",
                              "activeIngredient": "Methotrexate Sodium"
               }]
}]

Thanks.
Abhay

Confidentiality Notice
====================
This email message, including any attachments, is for the sole use of the 
intended recipient and may contain confidential and privileged information. Any 
unauthorized view, use, disclosure or distribution is prohibited. If you are 
not the intended recipient, please contact the sender by reply email and 
destroy all copies of the original message. Anju Software, Inc. 4500 S. 
Lakeshore Drive, Suite 620, Tempe, AZ USA 85282.

Reply via email to