Search with nested Fields on multi index

Elastic Stack Elasticsearch
1

I am using ES 7.1.I have my design in such a way each index contains single document type.For example - Suppose I have Order and some products in it. Order data is stored in one index and Products data in other index.

I want to search first 20 orders in ES (want data of both order and products) and display result on page(whole order data along with products) .How I can achieve this?
Searched for nested fields on multi indexing but cant get success.Please help

2

That is quite old. You should really consider upgrading.

If your data is in different indices I believe you will need to run 2 queries as Elasticsearch does not support joins. You could also perhaps use either parent-child relationships or nested documents to be able to do it in a single query.

3

Can we use parent child relationship / nested documents across index?