Hi. @dadoonet
Thanks
but i am looking for alternatives solution by using DSL Query.
we know very well its doesn't support Joins But is there any way of implement Join.
so we can work with current request.
Note:- i want DSL Query like below(but this is not join).
< { "size" : 1000, "query" : { "bool" : { "must" : [ { "bool" : { "must" : [ { "bool" : { "must" : [ { "terms" : { "relation.keyword" : [ "P", "S" ], "boost" : 1.0 } }, { "term" : { "user_id" : { "value" : 1016, "boost" : 1.0 } } } ], "adjust_pure_negative" : true, "boost" : 1.0 } }, { "term" : { "careprog_id" : { "value" : 7, "boost" : 1.0 } } } ], "adjust_pure_negative" : true, "boost" : 1.0 } }, { "term" : { "active.keyword" : { "value" : "Y", "boost" : 1.0 } } } ], "adjust_pure_negative" : true, "boost" : 1.0 } }, "_source" : { "includes" : [ "firstname", "lastname", "sex", "active", "relation" ], "excludes" : [ ] }, "docvalue_fields" : [ { "field" : "dob", "format" : "epoch_millis" }, { "field" : "user_patient_hrk" }, { "field" : "user_id" }, { "field" : "careprog_id" } ], "sort" : [ { "_doc" : { "order" : "asc" } } ] } />