Hello, you can strip grandchildren with [child parentFilter=otype:pf limit=500 childFilter='otype:(a p ap)'] If you need to get three level nesting you might probably check [subquery], but I suppose it's easier to recover hierarchy from what you have rigth now.
On Mon, Oct 3, 2016 at 7:38 PM, Juan Botero <[email protected]> wrote: > I am fairly new to Solr, so is possible I am writing the query wrong (I > have Solr 4.10) > > On this data: > [{ > "id": -1666, > "otype": "ao", > "parent_id": -1, > "parent_type": "root", > "name": "JOSHUA N AARON MD PA", > "account_number": "002812300", > "tax_id": "50042772325", > "group_npi": 134630688333, > "taxonomy": "364SP0808AAX", > "start_date": "2001-04-01T00:00:00.00Z", > "end_date": "2139-12-31T00:00:00.00Z", > "_childDocuments_": [{ > "otype": "p", > "parent_id": -1666, > "parent_type": "ao", > "id": 271, > "plan_id": "IBC", > "plan_url_identifier": "ibc" > }, { > "otype": "a", > "parent_id": -1666, > "parent_type": "ao", > "id": -88, > "line1": "216 E PULASKI STE 235", > "city": "Elkton", > "state": "MD", > "zip_code": "21921", > "_childDocuments_": [{ > "otype": "ph", > "parent_id": -88, > "parent_type": "a", > "id": 1, > "number": "5556201984" > }, { > "otype": "ph", > "parent_id": -88, > "parent_type": "a", > "id": 2, > "number":"5558696114" > }] > }, { > "id": -1988, > "otype": "ap", > "parent_id": -1666, > "parent_type": "ao", > "plan_provider_id": "00283621227", > "is_pcp": false, > "is_specialist": false, > "start_date": "2001-04-01T00:00:00.00Z", > "end_date": "2014-05-01T00:00:00.00Z", > "_childDocuments_": [{ > "id": -819, > "otype": "pf", > "parent_id": -1988, > "parent_type": "ap", > "npi": 139670334111, > "_childDocuments_": [{ > "otype": "n", > "parent_id": -819, > "parent_type": "pf", > "id": 1, > "prefix": "Dr.", > "first": "Frank", > "middle": "N", > "last": "Aaron" > }], > "organization_name": "Frank N Aaron", > "date_of_birth": "1963-03-18T00:00:00.00Z", > "gender_code": "M", > "is_individual": true > }] > }, { > "id": -1987, > "otype": "ap", > "parent_id": -1666, > "parent_type": "ao", > "plan_provider_id": "00283621007", > "is_pcp": false, > "is_specialist": false, > "start_date": "2001-04-01T00:00:00.00Z", > "end_date": "2014-05-01T00:00:00.00Z", > "_childDocuments_": [{ > "id": -815, > "otype": "pf", > "parent_id": -1987, > "parent_type": "ap", > "npi": 139670335001, > "_childDocuments_": [{ > "otype": "n", > "parent_id": -815, > "parent_type": "pf", > "id": 1, > "prefix": "Dr.", > "first": "Joshua", > "middle": "N", > "last": "Aaron" > }], > "organization_name": "Joshua N Aaron", > "date_of_birth": "1963-03-18T00:00:00.00Z", > "gender_code": "M", > "is_individual": true > }] > }] > }] > > This query: > q=otype:pf&fl=*,[docid],[child parentFilter=otype:pf limit=500] > > returns different documents in the childocuments array for each doc in > result, 2 oype:pf in total. But they have the same structure in the > datasource. I expected each to have one child, the otype:n document, but > each has a different set of children and both more than intended, why? > > CONFIDENTIALITY NOTICE > This e-mail message and any attachments are only for the use of the > intended recipient and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If you are not > the intended recipient, any disclosure, distribution or other use of this > e-mail message or attachments is prohibited. If you have received this > e-mail message in error, please delete and notify the sender immediately. > Thank you. > -- Sincerely yours Mikhail Khludnev
