Search with nested Fields on multi index

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

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.

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.