ElasticSearch Date Range for future date

Question

I am trying to create a query that will give me accounts that was created before a certain future date. I would like delete those account that were created 30 days before that future date. I am not sure how to write that range. Currently I have a query that gives me account that was created 30 days before today.

            range: {
                updatedAt: {
                  lte: "now-2592000/s",
                },
              },

Some guidance will be highly appreciated.

what format date? Could give example of document?

rabbitbr
– rabbitbr

2022-10-28 01:01:16 +00:00
Commented Oct 28, 2022 at 1:01 — rabbitbr
– rabbitbr, Commented Oct 28, 2022 at 1:01

jaspreet chahal · Accepted Answer · 2022-10-28 08:03:33Z

3

You can use _delete_by_query

POST <index-name>/_delete_by_query
{
  "query": {
    "range": {
      "createdAt": {
        "lte": "2022-10-31||-30d" --> any future date
      }
    }
  }
}

Pass any date with "||" at end.

My createdAt field is indexed using type "date"

edited Oct 28, 2022 at 8:03

answered Oct 28, 2022 at 3:10

jaspreet chahal

9,1392 gold badges14 silver badges30 bronze badges

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

2 Comments

Aman Mehta Over a year ago

He do not want to delete account created in last 30 days. Instead he has some future date. And want to delete all account 30 days less than that future that.

jaspreet chahal Over a year ago

@AmanMehta I have corrected the code

Collectives™ on Stack Overflow

ElasticSearch Date Range for future date

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related