Dear Discourse devs, admins and users.
is someone of you great folks able to help me to solve a EU GDPR request where I do have to provide the data next Tuesday?
With the great tool from @angus I was already able to extract as the admin quite a lot of information for the user who requested his data. @angus had fixed the bug that I first had encountered.
But in order to be prepared that also the 'administrative’ records with the user’s user_id
such as flags, complaints and staff whispers might also have to be provided, what would be the best SQL statements to get the data from the database with the data explorer?
I am not so familiar with the different tables and their structure and I want to avoid that I might extract incorrect information due to my missing knowledge of the different tables and their usage.
The German authorities are quite restrict with violations against the german data protection law (based on the EU GDPR regulations) and the user requests based on this law. I want to avoid to get a penalty for my organization by the authorities.
Any help will be appreciated
best regards
Guido