Delta Virtual Airlines Issue Report #4,218

DEVELOPMENT ISSUE #4,218 - Flight Academy Questions Statistics not updating?
Reported by	Jim Warner (DVA2533) on 03/22/2013 22:51 ET
Assigned To	Rahul Parkar (DVA8083)
Issue Status	Fixed on 09/15/2013 10:31 ET
Issue Priority	Medium
Airlines	Air France Virtual, Delta Virtual Airlines
Security	Public
Area	Web Site
Issue Type	Bug
Target Version	2.2
Issue Description	When looking up a question on the VFR Online Pilot test, I noticed that the statistics for "asked" and "correct" are not updating with the pilots taking the VFR Online Course. Is this something that we need to turn on in the examination question profiles? It appears that these statistics aren't being compiled only on the VFR Online Pilot Course questions.
9 ISSUE COMMENTS
Luke Kolin (DVA043) 04/08/2013 10:16 ET	I believe these are updating. They are somewhat expensive to calculate and therefore extensively cached.
Jim Warner (DVA2533) 04/08/2013 23:36 ET	I'm not so sure that they are updating. Look at the VFR instrumentation exam in the VFR OLP course. 2/3 rds of the questions have no statistics.
Rahul Parkar (DVA8083) 04/14/2013 14:25 ET	I'm not sure on this, looking at it, I'm sure these should be updating, but extensively cached as Luke says, I'll take a look.
Jim Warner (DVA2533) 04/23/2013 16:13 ET	Please check the code again as these questions on the VFR OLP course are not having their statistics updated as of today and the course has been open for more than 60 days. How long are the stats cached (extensively cached)? I need to see these statistics to determine if these questions aren't correct or are too obscure and hard to find answers to.
Jim Warner (DVA2533) 05/07/2013 12:19 ET	Gentlemen, Please look at the Flight Academy Question statistics for the VFR Online Pilot course (VFR Air Traffic Control, VFR Aircraft Systems, etc) as the new questions found at the bottom of the question lists for each test, are not being updated. The OLP course questions seem to be getting updated with statistics.
Rahul Parkar (DVA8083) 05/08/2013 20:31 ET	Apologies, I've been very busy, I'll look into this ASAP.
Luke Kolin (DVA043) 09/13/2013 10:23 ET	Cool beans. I've discovered all sorts of code I don't remember writing. It looks like auto-scored examinations don't get their question statistics updated. The challenge is going to be updating the data - that query might take a bit.
Luke Kolin (DVA043) 09/13/2013 10:42 ET	start transaction; truncate exams.QUESTIONSTATS; INSERT INTO exams.QUESTIONSTATS (SELECT EQ.QUESTION_ID, EP.ACADEMY, COUNT(EQ.CORRECT), SUM(EQ.CORRECT) FROM exams.EXAMQUESTIONS EQ, exams.EXAMS E, exams.EXAMINFO EP WHERE (EQ.EXAM_ID=E.ID) AND (EP.NAME=E.NAME) AND (E.ISEMPTY=0) GROUP BY EQ.QUESTION_ID);
Luke Kolin (DVA043) 09/15/2013 10:31 ET	Fixed in 449.

For flight simulation purposes only. Not a commercial website. In no way are we affiliated with Delta Air Lines, its affiliates, or any other airline. All logos, images, and trademarks remain the property of their respective owners. Delta Virtual Airlines is a non-profit entity engaged in providing an avenue for flight simulation enthusiasts.