lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Botero <juan.bot...@nanthealth.com>
Subject Multi-level nesting query inconsistency
Date Mon, 03 Oct 2016 16:38:44 GMT
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.
Mime
View raw message