Select all document id from exactly x days ago?

[vsr1]

@Chi

1)First I need to find all the distinct expiryDay from my bucket.

CREATE INDEX  ix1 ON default(expiryDay,timestamp);
SELECT DISTINCT expiryDay FROM default WHERE expiryDay IS NOT NULL;

@Chi

2)Then I need to query for keywords or documentIds whose expiryDay is let’s say 90 days and find the difference between the document’s timestamp with current-date and then again need to check the resulted difference is equal or greater than 90 or not. If yes then return the keywords or documentIds.

SELECT META().id FROM default WHERE expiryDay = 90 
               AND DATE_DIFF_STR(NOW_STR(),timestamp,"day") >= 90;