How to fetch data from multiple index using join like sql

Elastic Stack Elasticsearch
11

Hi,

I have created parent child relationship between two index type.but while searching it is giving no records.

my code is:

GET /join_query_logic/Wallet_Location_Dim/_search
{
"query": {
"has_child": {
"type": "User_Wallet_Location",
"query": {
"constant_score" : {
"filter" : {
"term" : {
"wallet_location_id" : 1
}
}
}
}
}
}
}

No results are found.But in User_Wallet_Location index type "wallet_location_id" : 1 is present.