Elasticsearch filtered query with script for term frequency

Question

I'm using the attachment plugin: https://github.com/elastic/elasticsearch-mapper-attachments

I'm able to find documents with a specific word in 1 or more fields but unable to filter documents with a lower term frequency than searched for.

This works:

POST /crm/employee/_search
{
"query": {"filtered": {
    "query": {"match": {
       "employee.cv.content": "transitie"
    }}, 
    "filter": {
       "bool": {
           "should": [
              {"terms": {
                 "employee.listEmployeeType.id": [
                    2
                 ]
              }}
           ]
       }
   }
}},
"highlight": {"fields": {"employee.cv.content" : {}}}
}

After a long search, I've found the following:

"script": {
          "script": "crm['employee.cv.content'][lookup].tf() > occurrence",
          "params": {
              "lookup": "transitie",
              "occurrence": 1
          }
       },

I'm unable to implement it unfortunately. I hope i've explained the issue good enough for someone to give me a push in the right direction!

Andrei Stefan · Accepted Answer · 2016-07-29 11:09:06Z

1

{
  "query": {
    "filtered": {
      "query": {
        "match": {
          "employee.cv.content": "transitie"
        }
      },
      "filter": {
        "bool": {
          "should": [
            {
              "terms": {
                "employee.listEmployeeType.id": [
                  2
                ]
              }
            }
          ],
          "must": [
            {
              "script": {
                "script": "_index['employee.cv.content'][lookup].tf() > occurrence",
                "params": {
                  "lookup": "transitie",
                  "occurrence": 1
                }
              }
            }
          ]
        }
      }
    }
  },
  "highlight": {
    "fields": {
      "employee.cv.content": {}
    }
  }
}

answered Jul 29, 2016 at 11:09

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch filtered query with script for term frequency

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related