User Story #1890
Updated by Kurt Gerber over 5 years ago
*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: <pre> 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' '6 months' </pre> 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 later than one year ago. 6 months. 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.