Hello everyone!
Hopefully an easy question for you all. What is the eQL I should be using for searching for all containers (documents) in eB / Assetwise that are at least 365 days old and are empty (i.e. they contain no files).
Regards
Chris
Chris,
I am assuming with "least 365 days old" it is based on the creation date. If so, you could use the following in 16.7:
START WITH Document SELECT Id, Code, Middle, Revision, Name, DateAdded WHERE IsTemplate = 'N' AND Files.Id IS NULL AND DateAdded <= DATECALC($Today, -365, DAYS)
Answer Verified By: Chris Marsh
Thank you, Michael. That worked a treat!