i need help how to create one search query in Elasticsearch.
Image we have index (login of clients) with 2 columns -> timestamp (when action happens) and user id.
What i would like to find what users have login after some date (for example this year) but not before this date (not previous years) .
In sql query would look like this:
WHERE A.timestamp > [DATE]
AND NOT IN (SELECT * FROM A WHERE A.timestamp < [DATE])
... and perfect would be, if returned 'userId' would be unique
thanks a lot