Hello,
I am trying to execute a join query that I am not 100% sure how to execute.
Lets say I have a bunch of parent and child documents and every one of my child
documents has a single value field “color”.
If I want to search all parents that have a “red” child, tis is very easy:
{!join from=parent to=id}color:red
However, if I want to return only parents that have both a red AND a blue item
it gets tricky.
This query would return parents that have red OR blue
{!join from=parent to=id}color:red OR color:blue
And this query would return nothing since no child had both colors.
{!join from=parent to=id}color:red AND color:blue
Any suggestions? My thinking is I might require some kind of custom query.
Thanks!
Darin
