get all nodes by metadata property value

edisonpaulgdev — Wed, 08 Jan 2025 20:38:10 GMT

When I called
http://<<ALFRESCO_SERVER>>/alfresco/service/api/server
I got

{ "data": { "edition": "Community", "version": "5.2.0 (re21f2be5-b22)", "schema": "10057" } }

Now, my objective is to purge (delete) all the documents (nodes) that has a (metadata) property value.

In version 5.2.0, I do not know if a plain Rest API is available where I can do the following:
Write a Java or another script (powershell, python) to call this rest api, to retrieve all nodes that has this property value, and then issue a delete for each. Make sure the deleted node would not be available in archive store.
Please let me know if this is possible.

I am working on a CMIS solution - Java program that uses CMIS. I find that deleting from here puts the content in archive store. Client is expecting a purge meaning there should not be any trace of these files right away. Somewhere I saw this recommendation that if I add this aspect - P:sys:temporary - to the document before issuing a delete, it will guarantee to not putting it in archive. I need to confirm this.

Also, I do not know if going behind the scenes to postgres database, and delete matching records from the active, version and archive stores in alf_node table is a correct and good idea.

To me, writing and deploying custom webscripts or an AMP/Jar will be time consuming. This is part of a product that is in end-of-life phase. If this is the only option, I can go with this.

Do you have any suggestions?

topic get all nodes by metadata property value in Alfresco Forum

get all nodes by metadata property value