User Story #1890
HIgh number of old drafts never submitted
Start date:
23 Sep 2019
Due date:
% Done:
0%
Estimated time:
Resolution:
Description
Problem:
High number of technologies with status 'Draft' only. A lot of them have pratically no content.
Number of such drafts with an age of more than 1 year: 627
SQL statement:
SELECT code,updated FROM questionnaire_questionnaire WHERE code LIKE 'technologies_%' AND status = 1 AND is_deleted IS false AND version = 1 AND updated < NOW() - INTERVAL '1 year'
Explanation on conditions:
- code LIKE ... : selects only questionnaires containing technologies
- status = 1 : Draft status
- is_deleted IS false: only versions/cases which are not deleted
- version = 1: If 'Draft' is the first version, then the technology was never published.
- updated < ... : That selects only cases which have been updated/save last time more than one year ago. This can be changed to anything with days, months, years.
That should be managed better. Else the database get's overloaded with bogus data.
Possible solution:- Sending an email to compilers after a certain time, if case was not updated anymore and not submitted
- After a certain time, delete the draft cases.
- Promote the demo version for tests and trainings.