Moodle

Normalize the storage of data

Details

  • Type: Sub-task Sub-task
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.9.5
  • Fix Version/s: None
  • Component/s: Feedback
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE

Description

Feedback currently stores multiple responses to the same question in the database separated by '|'. The possible answers for a question, mdl_feedback_item are stored similar to this:
c>>>>>High School Valedictorian (#1 in class)|High School Salutatorian (#2 in class)|National Honor Society Member|National Honor Society Officer|National Merit Finalist|National Merit Semi-finalist|National Merit Commended Scholar|Who's Who for High School Students|None of the above

This compels a query to perform programmatic funambulism in order to acquire what should be easily gotten results.

Activity

There are no comments yet on this issue.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated: