Nested SubQuery

[Ravi Dhanwate]

Hi All, 

We are using solar 8.2 and wants to know if we can have nested subqueries.

 For ex. I have following types of documents in my collection. Different 
document types are stored . ( Not using nested documents  to avoid indexing 
overhead).
    
 {
    Id :111,
    docType: “HEADER”
    Value: “Header Document”
}

{
    id:222
    headerId :111,
    docType: “LINE”
    Value: “Line Document”
}

{
    Id :333,
    lineId:222
    docType: “SHIPMENT”
    Value: “Shipment Document”
}

If I have subquery in below fashion, I can get headers and lines. Lines as 
nested document.

http://localhost:9881/solr/order-coll-scmdt/select?q=id:111&fq=doc_type:HEADER&fl=id,docType,linessub:[subquery]
&linessub.q={!terms f=headerId 
v=$row.id}&linessub.fq=docType:LINE&linessub.fl=id,doc_type

We want to have further level of nesting where can also find shipments for each 
line , however this type of query does not work.

http://localhost:9881/solr/order-coll-scmdt/select?q=id:111&fq=doc_type:HEADER&fl=id,docType,linessub:[subquery]
&linessub.q={!terms f=headerId 
v=$row.id}&linessub.fq=docType:LINE&linessub.fl=id,doc_type,shipments:[subquery]
&shipments.q={!terms f=lineId v=$row.id}&shipments.fq=doc_type:SHIPMENT

Are there any limitations on nested subqueries? 

Any help on this is appreciated.

Thanks
Ravi