Identifying Deleted Submissions in KoboToolbox Database

Kobo On Your Own Server
, ,
1

Hello everyone,

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?

Any insights would be greatly appreciated!

Thanks in advance.

2

anyone has any idea?

3

@YASSINE_BEN_AATA, if you can also find this in Django UI>Thrash bin.

4

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?

5

anyone has any idea?