Hi Guys,
I am trying to filter a result from indexA using a record from lookup indexB. ie the foreign key from document in indexA should match with a field inside a record in indexB. Where i can specify the id of record. And then match with id of a specific field and foreign key.
{"join" : {
"indices" : ["indexB"],
"on" : ["userId", "<StaticRecordID>.id"],
"request" : {
"query" : {
"bool": {
"must" :[ {"term" : {
"someCondition" : true
}}
]
}
}
}
}
I need to match foreign key of document in indexA (userId) with field id inside a record of static id say 121