DSL query thats compares the same data from different dates

Elastic Stack Elasticsearch
1

Hello everyone , i'am trying to make a query like that in DSL , the goal is to be able compare terms based on a date range . is it possible to do that we DSL Query ?
Query :

SELECT
fqdn
FROM
visited_urls
WHERE
MIN(date_visited) BETWEEN CURDATE() AND CURDATE() - 1
AND fqdn NOT IN (
SELECT DISTINCT fqdn
FROM
visited_urls
WHERE
date_visited BETWEEN CURDATE() - 2 AND CURDATE() - 30

Kind regards

2

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