Range query for Nested Documents for Keyword Type

Elastic Stack Elasticsearch
1

Hello

I have a document structure like this. For this below two documents, we have nested documents called interaction info. I just need to get only the documents that have title duration and their value is greater than 60

Here whats the catch the value field is keyword not an integer. I know that only for the Integer Range query will get executed. Is there any possible way to find the documents that has duration greater than 60 ( Painless Query or Script Query )

{
    "key": "f07ff9ba-36e4-482a-9c1c-d888e89f926e",
    "interactionInfo": [
      {
        "title": "duration",
        "value": "11"
      },
      {
        "title": "timetaken",
        "value": "9"
      },
      {
        "title": "talk_time",
        "value": "145"
      }
    ]
  },
  {
    "key": "f07ff9ba-36e4-482a-9c1c-d888e89f926e",
    "interactionInfo": [
      {
        "title": "duration",
        "value": "120"
      },
      {
        "title": "timetaken",
        "value": "9"
      },
      {
        "title": "talk_time",
        "value": "60"
      }
    ]
  }
2

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