Filter match using a query

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
}

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.