add SGQ code to questions selector, proper questions list order
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
queXS |
Fix Released
|
Low
|
Unassigned |
Bug Description
common for quota.php and quotarow.php :
1. tables with quotas show only SGQ code for questions, selector shows only question description, so when we need to add/edit/
Suggest to add SGQ code to questions selector
2. current questions sort order doesn't reflect questionnaire questions sequence, query order requires modifications
To fix: replace parts of querries (starting row 420 in quotarow.php, row 180 in quota.php ) in both files
To add SGQ to selector replace " CASE WHEN lq.parent_qid = 0 THEN lq.question ELSE CONCAT(
With " CONCAT( lq.sid, 'X', lq.gid, 'X', CASE WHEN lq.parent_qid = 0 THEN lq.qid ELSE CONCAT(
To change sort order replace " ORDER BY g.group_order ASC, lq.question_order ASC "
With " ORDER BY CASE WHEN lq2.question_order IS NULL THEN lq.question_order ELSE lq2.question_order + (lq.question_order / 1000) END ASC "
Changed in quexs: | |
status: | New → Fix Committed |
Changed in quexs: | |
importance: | Undecided → Low |
milestone: | none → 1.12.1 |
Changed in quexs: | |
status: | Fix Committed → Fix Released |
The same SGQ story with questionnairepr efill.php
To show SGQ code in selector change qo.question, ' : ',q.question) END as description " qo.question, ' : ',q.question) END) as description "
" CASE WHEN qo.question IS NULL THEN q.question ELSE CONCAT(
to
" CONCAT( q.sid, 'X', q.gid, 'X', q.qid, ' -> ' , CASE WHEN qo.question IS NULL THEN q.question ELSE CONCAT(