Friday, July 3, 2020

Fetching results in Elassandra for a date range

 Below is the curl command to fetch results from Elassandra Database for a given date range.

$ curl -XGET -H 'Content-Type: application/json' 'http://x.x.x.x:9200/eltabby_idx/_search?pretty=true&error_trace=true' -d '
{
  "size" : 1,
  "query" : {
    "bool" : {
      "must" : {
        "match" : {"address": "pp.kk@ppk.com"}
      },
    "filter" : {
      "range" : {
        "sent_date" : {
          "gte": "2024-06-11 17:30:46+0000",
          "lte": "2039-06-11 17:30:46+0000"
        }
      }
    }
    }
  }
}'

No comments:

Post a Comment