Forum Discussion
christopher_gillis
5 years agoCommunity Manager
Hello,
For one-time data fixes like this, I'd recommend using a SQL query. While it would be possible to write an AML query to do this, you would need to make sure that all of the documents you want to update are in an editable state. Depending on the versioning logic on your documents, an AML query may also lead to some unexpected versioning since this isn't really a noteworthy change.
As a general note before you run any SQL query, I'd recommend taking a backup of the database just to be safe. Also, if you have a future use case where a query is going to be run repeatedly, I would not recommend writing that using a SQL query as it bypasses the Aras permission model.
Chris
Christopher Gillis
Aras Labs Software Engineer