
Hi I want to have possibility to save history of changes on collection. When I save some changes, old value should save in another "history" collection. It should works like "before update" Trigger in SQL. What is best approach to do it in Appwrite?

You need to do this to a specific collection or all your collections?

for now only 1 collection

I did something similar in a project:
I created a function to process my requests (I call this function for each request). In the function I passed the databaseId
, collectionId
, and data to update. I did a similar endpoint to edit a document (it included documentId
).
Then In the function I requested the current data, logged in a different collection, and then update it. I don't know if that meets your needs

<@688415252471349251>

Ok. So am I good understand. I have to create function only to save specific document in history collection, and next I have to trigger this function when I'm updating document in my "real" collection?
Recommended threads
- Query params are way too limiting in ter...
I was trying to list rows in a table that do not already exist in another table. I retrieved around 260 row IDs which are 13 characters in length each, and then...
- Relationship null, even when relationshi...
Hi Everyone, im experiencing issues with set relation data. When im setting the document id from the related database most of them seem fine, except one table. ...
- REQUEST FAILED IN MIGRATION
I was trying to moved my archived project to a self-host database . Though the Project is "read only" but there's a message that I can view and migrate data to...
