Project

General

Profile

User Story #1890

HIgh number of old drafts never submitted

Added by Kurt Gerber about 5 years ago. Updated about 5 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
-
Target version:
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.
#1

Updated by Kurt Gerber about 5 years ago

  • Description updated (diff)

Also available in: Atom PDF