Hi there,
I have the below query on a filter. There is also another query in the filter to makes up the filter. But it doesn't work at all. I mean the filter is not able use the names from "school" to filter on "male" table.
{
"query": """
SELECT
name
FROM male
""",
"filter": {
"match": {
"name": {
"query": """
SELECT
name
FROM school
"""
}
}
},
"fetch_size": 50
}