How to get results from another results field value

Hi Everyone,

I need to implement a query when the results are returned, from that I need to take one field value then need to get another result from the field,


From the above screenshot, I got some results based on my query. Here i need to get another results by using ParentAssignmentID value like self join in sql.

Please suggest your thoughts on this.

Thank you!


You need to send another query then after the first one. You can not really "join" in Elasticsearch.

Thank you David!

I need to get only 200 records every time depends on the grid length. I need to merge two result at once and get 200 records. But here what happens is getting 200 records at first query after then 20 records from the seconds query and both results are coming from same type. After merging two results it becomes 220 records.. But i need to get only 200 records as per grid length.

Share your thoughts on this.

May be explain with a more detailed example and we could find if there is another solution?

Could you provide a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script is something anyone can copy and paste in Kibana dev console, click on the run button to reproduce your use case. It will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

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