Hello everyone,
Internal assessment creation is a simple step but how do you add a mistakenly left out class so that it doesn’t appear odd on the report card(so that it doesn’t appear like a new internal assessment) .
Either edit the created one as a bulk or combine in a SQL statement (it is the first created so a destructive SQL will not destruct previous assessments)
Hi Kelvin, thanks for sharing. I’m not sure, are you asking this as a question or sharing your findings? If it’s the latter, feel free to share the example SQL if you feel it will be helpful to others as well. Thanks!
Hi Sandra, yes this SQL will help if it happens to be multiple column and tedious changing one by one:
go to DB open table gibbonInternalAssessmentColumn and confirm the gibbonInternalAssessmentColumnID number of the first and last assessment that you need to change/rename/combine and set them as:
first ID=x
last ID=y
then run the following SQL:
BEGIN
DECLARE counter int ;
SET counter = y;
WHILE counter>=x DO
UPDATE gibbonInternalAssessmentColumn SET name = ‘TERM 1 OPENER EXAM’ WHERE gibbonInternalAssessmentColumn.gibbonInternalAssessmentColumnID = counter;
SET counter = counter - 1;
END WHILE;
END`
This can be a temporary solution before bulk editing feature is added.