To show SGQ code in selector change
" CASE WHEN qo.question IS NULL THEN q.question ELSE CONCAT(qo.question,' : ',q.question) END as description "
to
" CONCAT( q.sid, 'X', q.gid, 'X', q.qid, ' -> ' , CASE WHEN qo.question IS NULL THEN q.question ELSE CONCAT(qo.question,' : ',q.question) END) as description "
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(