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 ?
MIN(date_visited) BETWEEN CURDATE() AND CURDATE() - 1
AND fqdn NOT IN (
SELECT DISTINCT fqdn
date_visited BETWEEN CURDATE() - 2 AND CURDATE() - 30