Matrix Question - Displayorder not set correctly

[w3devpro]

1. ISSUE/ BUG/ ERROR

a. Expected Behaviour

The order of the rows in a matrixquestion should be the same on the survey contentbuilder, the survey form, the voterreport and any other listing and exports etc.

b. Actual Behaviour

The order in which the rows on the matrix question are presented varies depending on the webpage it is displayed on.

c. Steps to Reproduce Behaviour

1. Create Matrix question, add multiple rows
2. Answer and submit the survey and check the answers on the voterreport
3. The order of the rows will not (always) be consistant.

d. Possible Cause and/or Solution

The displayorder field in the vts_tbquestion table is not set properly in case of matrix questions. The displayorder value of the main (parent) question is copied to the child questions. It can be fixed by correcting the stored procedure for (new) matrixchild questions.

e. Technical Specifications

• Version of Survey Project: all
• Type of Device (pc, laptop, tablet, mobile): all
• Browser Type & Version: all
• Operating System: all

f. Context (Environment)

In matrix questions where the row order is important because of interrelated voteranswers the relation is lost because the sort order varies and cannot be replicated properly.