I'm new to Elasticserch and I'm looking for a way to find all parents base on a query but also bring up parents based on their children.
Example:
Parent records
ID Text
1 bob
2 john
3 bobby
Child Records
ID ParentID Text
11 1 phone
22 2 bob
33 3 green
I want to search "bob" and find all 3 parent records.
Parent ID 2 will come up in results based on Child 22 Text "bob"
Is this possible?