I am trying to run a query that will pull results based on a boolean must-match query and a has_parent query. However, I don't know how to fit these two parameters together. The two queries that I want to merge together are as follows:
$params = [
'body' => [
'query' => [
'match' => [
'city' => 'UK'
]
]
]
];
$paramsTwo = [
'body' => [
'query' => [
'has_child' => [
'type' => 'asset',
'query' => [
'bool' => [
'must' => [
'match' => ['asset_type' => 'Hot Desk']
],
'should' => [
'match' => ['description' => 'coffee']
]
]
]
]
]
]
];
I want to find the venues
(parents) in the 'UK'
that have assets
(children) which are also 'hot desks'
and should be coffee
-related.
Any help?
T. Okai