A problem with numeric range query

Elastic Stack Elasticsearch
1

Hi,

My name is David and I have a problem with a query.
I tried to search the forum for similar topics but I haven't found anything, I appreciate any help in advance.
This is the query that is giving me problems:

{
  "query":{
    "bool":{
      "must": [
        {"nested": {
          "path": "valores",
          "query": {
            "range": {
              "valores.dESDE_TRANSF": {
                "gte": 962031395626955
              }
            }
          }
        }},
        {"nested": {
          "path": "valores",
          "query": {
            "range": {
              "valores.hASTA_TRANSF": {
                "lte": 962031395626955
              }
            }
          }
        }}
      ]
    }
  }
}

The results that the query returns do not match this one

Result 1 =>

 "valores" : {
            "hASTA_TRANSF" : 962031425341212,
             "dESDE_TRANSF" : 962031425341212
}

Result 2 =>

"valores" : {
            "hASTA_TRANSF" : 962031401341185,
            "dESDE_TRANSF" : 962031401341185
}

Why?

This is my mapping configuration for these fields:

"hASTA_TRANSF" : {
                "type" : "float"
              },
"dESDE_TRANSF" : {
                "type" : "float"
              },

Thanks in advance.
Best regards.

2

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