How to filter records by date in elasticsearch with date modification?

Question

elasticsearch

To filter by date, I use the following queries:

'body'  => [
    'query' => [
        'bool' => [
             'filter' => [
                  'range' => [
                      'expire_at' => [
                          'gte' => now()
                      ]
                 ]
             ]
         ]
    ]
]

UPD: Each entry has one more date field - last_checked. The question is how to select records in which for example expire_at - 7 дней > last_checked?

Answer 1

Try to use script-request https://www.elastic.co/guide/en/elasticsearch/ref...