| Administrator's Handbook |
| Edutizer manuals | Administrator handbook | A2 Manage | Various database scripts | How to correctly query examresults from database? |
How to correctly query examresults from database?
If you want to directly read examresult for a training from the database, use the following query
exec [dbo].[sp_TrainingExamResultsList] <training_id>
where <training_id> is the id of the training.
Following are the columns returned by this query that may be of interest:
| user_name | First and last name of the student |
| exam_date | date and time student started the exam |
| result | test result in percent. -100 means student did not take the test |
| passed | Automatic result assesment based on defined success criterium. Note: This is not the final result of the exam. 0 = test result below success criterium 1 = test result above success criterium |
| mark |
Training (exam) result. This may differ from result as it can be changed by teacher 0 = did not pass 1 = passed -1 = did not participate |
| comment_txt | Teacher free-form comment. |
|
||||||
| ||||||
|
||||||
