I would like to use the out of One query as input in another but dont know how.
Index1: (Field 1, Field 2, Field 3)
Index2: (Field 3, Field 4, Field 5)
Select Field 2 from from Index1 where Field 3 = (select Field 3 from Index 2 where Field 5 = 'user input'))
Basically this goes towards joining two indexes .. and getting the results from two indexes in one query. I am not sure if this is possible in ES.
One easy way would be to merge Index 1 and Index 2 in one but that's not the possibility in the use case as the source are different for both.