I’m using a self-hosted KoboToolbox instance and retrieving submission data directly from the database for reporting purposes. I noticed that the reversion_version table contains all submission data, but I can’t find any column indicating whether a submission has been deleted.
Even when a submission is deleted from the KoboToolbox interface (under the “Data” section), it still remains in the reversion_version table, with no obvious flag showing it has been removed.
Is there a way to identify deleted submissions? Or am I missing a better approach to extract submission data, including their deletion status?
Thank you for your response, KaL_Lam. I can only see deleted users or forms in the interface. However, I need to access this information programmatically rather than through the UI, as I am querying form data directly from the PostgreSQL database for reporting purposes. am i doing something wrong, should i use another method to retreive form data for reporitng in an external web app?
Interesting question. From what I’ve seen, deleted submissions may still exist in revision/history tables for audit purposes, while the active records are removed from the main submission tables. It could help to compare IDs between the current data table and reversion_version entries to identify deleted records more reliably.
Thanks for the helpful explanation. Comparing the current submission table with the revision/history records seems like a practical way to identify deleted submissions while preserving audit information.
