View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17943Feature requests_ Unknownpublic2022-03-11 14:54
Reportergwdgls Assigned To 
PrioritynoneSeverityfeature 
Status newResolutionopen 
Summary17943: Request to enhance the check data integrity function
Description

The function to delete tables of removed surveys from the database is crucial for data protection, at least in GDPR countries, regarding tables with personal data, e.g. participants' tables.

Feature requests.

  • Filter by the tables' age
  • Filter by survey owners
  • Display a dialogue to the survey owner after they deleted a survey - or at logout - asking them to perform the function for their own deleted survey(s).
  • For the "general" function invoked by the server admin: more comfy user interface with sorting / filtering possibilities as proposed above and "check / uncheck all"
Additional Information

When a survey is deleted via the user interface, the questionnaire and resources (uploads) are deleted. Data tables, however, remain in the database until the data integrity check is done.

If hosting an installation with many survey administrators, the server admin won't know when a survey is deleted, so they would usually perform the function on a regular basis. However, they won't know whether the deleted survey's admin might want to reactivate it at a later date and wants to keep these tables for re-importing.

Tagsdata integrity, data protection
Bug heat4

Relationships

related to 17094 new checkintegrity (and fix) by survey 
related to 17947 new Enhancing check data integrity function: Adding options to filter results 
related to 17948 new Enhancing check data integrity function: Option / alert for survey admins to delete their deleted surveys' database tables 

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-03-10 18:27

developer   ~68616

By Survey needed ;)

DenisChenu

DenisChenu

2022-03-10 18:28

developer   ~68617

Display a dialogue to the survey owner after they deleted a survey - or at logout - asking them to perform the function for their own deleted survey(s).

It's not done when delete survey ?
It must be without other action or confirmation.

DenisChenu

DenisChenu

2022-03-10 18:30

developer   ~68618

When a survey is deleted via the user interface, the questionnaire and resources (uploads) are deleted. Data tables, however, remain in the database until the data integrity check is done.

This is an spearated bug in my opinion.

  1. Feature request #1: have filter, by age, by user etc
  2. Feature request : by survey
  3. Feature request : by non super admin user on his onw survey
  4. Bug : old table are not deleted when survey is deleted.
gwdgls

gwdgls

2022-03-11 12:56

reporter   ~68629

OK, I'm writing a feature request for each of these.

Question: Is there a reason why 2. (filter by survey) is a separate request from 1.?

gwdgls

gwdgls

2022-03-11 13:09

reporter   ~68631

Another Question: 4. would make 3. redundant, right?

gwdgls

gwdgls

2022-03-11 13:14

reporter   ~68632

17947: 1. and possibly 2.

17948: 3.

Is 4. really a bug?
Someone said somewhere that sometimes a user wants to keep tables in order to re-use them in another survey. So maybe this is also a feature request:

  • Create possibility for super admin (for the entire installation) and/or for survey admin (for their surveys only) to decide whether database tables are to be deleted immediately with the survey deletion or if they choose to keep them for a longer time. "and" would be best :)
gwdgls

gwdgls

2022-03-11 13:15

reporter   ~68633

https://bugs.limesurvey.org/view.php?id=17947
https://bugs.limesurvey.org/view.php?id=17948

DenisChenu

DenisChenu

2022-03-11 14:54

developer   ~68637

Remind : it's just my personal opinion :).

About «sometimes a user wants to keep tables in order to re-use them in another survey.» but then : we don't keep current token table and survey table …
If needed : can use VV export/import

We delete current survey table but not old survey table : my opinoon : it's an issue :)

Issue History

Date Modified Username Field Change
2022-03-09 09:33 gwdgls New Issue
2022-03-10 18:26 DenisChenu Relationship added related to 17094
2022-03-10 18:27 DenisChenu Note Added: 68616
2022-03-10 18:27 DenisChenu Bug heat 0 => 2
2022-03-10 18:28 DenisChenu Note Added: 68617
2022-03-10 18:30 DenisChenu Note Added: 68618
2022-03-11 12:56 gwdgls Note Added: 68629
2022-03-11 12:56 gwdgls Bug heat 2 => 4
2022-03-11 13:03 gwdgls Tag Attached: data integrity
2022-03-11 13:03 gwdgls Tag Attached: data protection
2022-03-11 13:09 gwdgls Note Added: 68631
2022-03-11 13:14 gwdgls Note Added: 68632
2022-03-11 13:15 gwdgls Note Added: 68633
2022-03-11 14:54 DenisChenu Note Added: 68637
2022-03-11 14:54 DenisChenu Relationship added related to 17947
2022-03-11 14:54 DenisChenu Relationship added related to 17948