cancel
Showing results for 
Search instead for 
Did you mean: 

get all nodes by metadata property value

edisonpaulgdev
Champ in-the-making
Champ in-the-making

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?

0 REPLIES 0