we want to search for pages that have not been published that were created before 1 year ago and delete them but there is not the option in the search console.
AEM 6.1. Does anyone have a solution?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
If you don't mind deleting the pages by hand (if there aren't many) you can use the following SQL-2 query in CRX (by going to Tools.. > Query and changing the language to JCR SQL 2) and just click and delete each result (you'll have to adapt the date in the query):
select * from[cq:Page] as page inner join [cq:PageContent] as content on ischildnode(content, page) where content.[cq:lastReplicated] is null and page.[jcr:created] < CAST('2020-05-18T00:00:00.000Z' AS DATE)
If you need to delete the pages programmatically, I suggest creating a workflow. This sounds like the sort of thing you might do every year? Or more often even, if you wanted to. With a workflow, you can develop it once and then just launch it any time you want 🙂
You can create a workflow using the techniques in this tutorial. The workflow should:
Hope that helps 🙂
Just sharing QueryBuilder code as well in case you want to use it or get a result as json