elasticsearch nested queries

Question

I'm reading my queries from my database and I add some filter in java side but the code doesn't work. I will read the part between stars from my database. Sorry for bad English. how can I make it work ,my query is:

{
  "from": 0,
  "size": 100,
  "query": {
    "filtered": **{
      "query": {
        "bool": {
          "should": [
            {
              "match": {
                "text": {
                  "query": "xxx",
                  "slop": 0
                }
              }
            },
            {
              "match": {
                "text": {
                  "query": "xbxxı",
                  "slop": 0
                }
              }
            }
          ],
          "minimum_should_match": 1,
          "boost": 1.0
        }
      }
    }**,
    "query": {
      "myFilter": {
        "filter": {
          "bool": {
            "must": [
              {
                "range": {
                  "date": {
                    "gt": "2015-09-08",
                    "lte": "2015-09-09"
                  }
                }
              },
              {
                "query": {
                  "match": {
                    "page": "1"
                  }
                }
              },
              {
                "range": {
                  "xxxx": {
                    "gt": "0.0"
                  }
                }
              }
            ]
          }
        }
      }
    }
  }
}

Ryan Huynh. · Accepted Answer · 2015-09-10 01:42:30Z

1

The filtered you load from database is valid, however the problem is the query you define outside of ** .

"query": {
  "myFilter": {
    "filter": {
      "bool": {
        "must": [
          {
            "range": {
              "date": {
                "gt": "2015-09-08",
                "lte": "2015-09-09"
              }
            }
          },
          {
            "query": {
              "match": {
                "page": "1"
              }
            }
          },
          {
            "range": {
              "xxxx": {
                "gt": "0.0"
              }
            }
          }
        ]
      }
    }
  }
}

If you want to use this filter you have define it right after "query" inside your filtered.

{
"from": 0,
"size": 100,
"query": {
   "filtered":** {
      "query": {
        ...
      }**,
      "filter": {
         "bool": {
            "must": [
               {
                  "range": {
                     "date": {
                        "gt": "2015-09-08",
                        "lte": "2015-09-09"
                     }
                   }
                },
                {
                   "query": {
                       "match": {
                          "page": "1"
                        }
                    }
                 },
                 {  
                    "range": {
                       "xxxx": {
                          "gt": "0.0"
                        }
                    }
                 }
              ]
           }
         }
      }
   }
 }

answered Sep 10, 2015 at 1:42

Ryan Huynh.

3062 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fatih Aktepe Over a year ago

I know that works like that. but the query I get from database is a formal query so the last paranthesis that has is closing the filtered part so filter will be placed out side of the query. I want a solution for this.

Collectives™ on Stack Overflow

elasticsearch nested queries

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related