Dear sirs, I am testing AriQuziLite as a pre-exam quiz for students.
I choosed the 'Random Question' option for quiz and in the Result page for a single user (StatisticsInfoId from _ariquizstatisticsinfo) I can see results sorted in the order answers were proposed to user during quiz.
May I use a db query to have those results sorted like my Quiz questions order?
I see QuestionVersionId from _ariquizstatistics is the version of question, but when questions are modified/revised many times the range of QuestionVersionId is very large and not useful to identify a single question.
Thank you for your great job!
LC

Hello,

Do you mean ordering of questions or answers on questions?

Regards,
ARI Soft

Tank you for your fast reply.
I mean order of questions in Results page for one user, that I would like to query from db, so if I have a large number of questions not sorted it is difficult to find a particular question and compare users answers.
By the way the answers of a single question Result page are already sorted in the order I composed them (perhaps because Randomization option is not present for Answers but only for Questions presentation in Quiz).
LC

Probably you can send image(s) with comments what do you want to achieve?

Regards,
ARI Soft

Thanks for your reply and sorry for my confusion:
in Quiz Question List page Questions are in order 01-02-03-04, as the Quiz has the 'Random Question' option set on, questions are proposed in random order to user and in the user's 'Result Page' are shown in the ordere they were proposed 03-02-04-01.
If we have a large number of questions, it becomes difficult to find a particular question at once if they are sorted in random order in the Result page.

I would like to query my db to have the Result page for one user and relative Questions ordered like in Quiz Question List.
LC

The extension shows questions on quiz results page in the same order like they were shown during a quiz session for quiz taker. If you want to change this behavior, you can modify the extension. See "getResultList" method in <joomla_directory>\administrator\components\com_ariquizlite\kernel\Controllers\class.ResultController.php file.

Regards,
ARI Soft