Block Join Child Query returns incorrect result

[kristaclaire14]

Hi,

I'm having a problem in my solr when querying third level child documents. I
want to retrieve parent documents that have specific third level child
documents. The example data is:

[{ 
    "id":"1001" 
    "path":"1.Project", 
    "Project_Title":"Sample Project", 
    "_childDocuments_":[ 
    { 
        "id":"2001", 
        "path":"2.Project.Submission", 
        "Submission_No":"1234-QWE", 
        "_childDocuments_":[ 
        { 
            "id":"3001", 
            "path":"3.Project.Submission.Agency", 
            "Agency_Cd":"QWE" 
        } 
        ] 
    }] 
}, { 
    "id":"1002" 
    "path":"1.Project", 
    "Project_Title":"Test Project QWE", 
    "_childDocuments_":[ 
    { 
        "id":"2002", 
        "path":"2.Project.Submission", 
        "Submission_No":"4567-AGY", 
        "_childDocuments_":[ 
        { 
            "id":"3002", 
            "path":"3.Project.Submission.Agency", 
            "Agency_Cd":"AGY" 
        }] 
    }] 
}] 

I want to retrieve the parent with *Agency_Cd:ZXC* in third level child
document.
So far, this is my query:
q={!parent which="path:1.Project" v="path:3.Project.Submission.Agency AND
Agency_Cd:ZXC"}

My expected result is 0 but solr return parents with no matching child
documents based on the query. Am I doing something wrong on the query?
Thanks in advance.



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html