Add Backend support and REST interface for Exam Delete
Issue #1388
resolved
This will for now provide a means of deleting an incorrectly added exam, as a sysops operation. Evntually this can be made accessible from the front-end, with adequate security and validation.
Comments (6)
-
reporter
-
reporter
In MIEMIS the 3 records 107 108 109 without exCode have been correctly loaded as 110 M03. They have been removed in production and MIEMIS-TEST
-
reporter
KEMIS has one null Exam record, missing Year. Has no candidates, safe to remove
-
reporter
- changed status to open
-
reporter
examWriteX.DeleteExam has been created and propogated through databases.
Not accessible via app backend, but few Delete operations are.
-
reporter
- changed status to resolved
task(exams): sql support for exam delete, table minor cleanup
Resolves
#1388→ <<cset ad41df8b90b1>>
- Log in to comment
Exams without exCode exist in both MIEMIS and FEDEMIS systems. This procedure will be used to clean these up. After these records are removed , make exCode and exYear mandatory on Exams table.
As well, make the primary key (on int exID Identity) CLUSTERED. Indexes on Identities should be clustered, indexes on uniqueidentifiers definitely should NOT be clustered!