1 - Create a new question with a 'table' type (type F)
2 - Add 3 subquestions like this : A, B and C
3 - Add 3 answer options like this : 1, 2 and 3
3 - Select random order in the display settings of the question
4 - Save the question
Content in the lime_question_attributes table at this moment :
qaid | qid | attribute | value | language
---------+--------+----------------------+-------+----------
1682391 | 639573 | min_answers | |
1682392 | 639573 | max_answers | |
1682393 | 639573 | array_filter | |
1682394 | 639573 | array_filter_style | 0 |
1682395 | 639573 | array_filter_exclude | |
1682396 | 639573 | exclude_all_others | |
1682397 | 639573 | random_group | |
1682398 | 639573 | em_validation_q | |
1682399 | 639573 | em_validation_q_tip | | fr
1682400 | 639573 | repeat_headings | |
1682401 | 639573 | answer_width | |
1682402 | 639573 | random_order | 1 |
1682403 | 639573 | hide_tip | 0 |
1682404 | 639573 | hidden | 0 |
1682405 | 639573 | cssclass | |
1682406 | 639573 | use_dropdown | 0 |
1682407 | 639573 | printable_help | | fr
1682408 | 639573 | page_break | 0 |
1682409 | 639573 | scale_export | 0 |
1682410 | 639573 | public_statistics | 0 |
1682411 | 639573 | statistics_showgraph | 1 |
1682412 | 639573 | statistics_graphtype | 0 |
1682413 | 639573 | image | |
1682414 | 639573 | save_as_default | N |
5 - Edit the question and change its type like this : multiple choice bootstrap button (type M)
6 - The 3 subquestions are still here
7 - Be sure that the normal order is selected in the display settings of the question
8 - Save the question
9 - Preview the question ... The display order of the subquestions is random and not normal !!!!
Content in the lime_question_attributes table after this change :
qaid | qid | attribute | value | language
---------+--------+-------------------------+--------+----------
1682418 | 639573 | other_replace_text | | fr
1682419 | 639573 | subquestion_order | normal |
1682420 | 639573 | display_columns | |
1682421 | 639573 | other_position | end |
1682422 | 639573 | other_position_code | |
1682423 | 639573 | button_size | |
1682391 | 639573 | min_answers | |
1682392 | 639573 | max_answers | |
1682393 | 639573 | array_filter | |
1682394 | 639573 | array_filter_style | 0 |
1682395 | 639573 | array_filter_exclude | |
1682396 | 639573 | exclude_all_others | |
1682397 | 639573 | random_group | |
1682398 | 639573 | em_validation_q | |
1682399 | 639573 | em_validation_q_tip | | fr
1682400 | 639573 | repeat_headings | |
1682401 | 639573 | answer_width | |
1682402 | 639573 | random_order | 1 |
1682403 | 639573 | hide_tip | 0 |
1682404 | 639573 | hidden | 0 |
1682405 | 639573 | cssclass | |
1682406 | 639573 | use_dropdown | 0 |
1682407 | 639573 | printable_help | | fr
1682408 | 639573 | page_break | 0 |
1682409 | 639573 | scale_export | 0 |
1682410 | 639573 | public_statistics | 0 |
1682411 | 639573 | statistics_showgraph | 1 |
1682412 | 639573 | statistics_graphtype | 0 |
1682413 | 639573 | image | |
1682414 | 639573 | save_as_default | N |
1682415 | 639573 | other_numbers_only | 0 |
1682416 | 639573 | assessment_value | 1 |
1682417 | 639573 | exclude_all_others_auto | 0 |
1682424 | 639573 | max_buttons_row | |
The 'random order' (which is a 'table' type display parameter) is still in the database and is used in place of the 'subquestion_order' parameter (which is a 'multiple answer' type display parameter).
So, when you change the type of a question, it would be nice to keep the attributes related to the new question type and to delete in the database (table 'lime_question_attributes') the attributes only related to the old question type |