What is the best way to search and sort JCR nodes[having references to another set of nodes] based on a properties on the referenceable nodes they are referencing ?
Please look at the below sample node structure
Parent-node-a
Child-node-a1
: name - String - Test1
: propertyX- Reference - uuid1
Child-node-a2
: name - String - Test2
: propertyX- Reference - uuid2
…..
Parent-node-b
Child-node-b1
: title- String - TestTitle1
: id - String- 123
: jcr:uuid - uuid1
Child-node-b2
: title- String - TestTitle2
: id - String- 453
: jcr:uuid - uuid2
Now I would like to search and sort child nodes under parent-node-a based on the tile property on the nodes they are reference from parent-node-b. Appreciate any guidance here.