How can we convert join query into elastic search

Hi @dadoonet .

Thanks

but i don't have idea about implementation of parent_child and nested query.

Note :- i have one more complex issue please review and please try to help?

Thanks