Certificate Related Problems

Verify new/updated certificate template:
General process:
- put certificate template files in folder <organization>/CertificateTemplates of your local machine
- if the certificate template requires template resources like image, css files, put those files in corresponding file collection folder (you can find the folder using command getFileCollectionRoot)

- (for new templates) add that certificate to the system using CreateCertificate
- (for new templates) add a rule using AddCertificateRule to tell system when to award this certificate (like StudentResultBetterThan(99,sco-Status):HACCP means student got mark higher than 99 in the course HACCP)
- trigger the rule you just added (i.e. take the exam, or assess the student using assessor account)
- go to course and click Manage → Reports → Grades (by student) → find the user you just triggered → click view button. Now you can find the certificate you just awarded
Sample task:
https://rippleops.atlassian.net/browse/SUCO-653
Verify the awarded certificate data
General process:
- award certificate to user following previous steps
- open mysql server management studio → find table CertificateAudit in the database you want to test with → right click and select either “Select Top 1000 Rows” or “Edit Top 200 Rows” → then you can verify/filter the record you want by either certificate name/shortId/awardedUserId or dateCreated

- find the table “AuditCertificateState“ of the database you want to test with → right click and select either “Select Top 1000 Rows” or “Edit Top 200 Rows” → filter the record you want by AssigningUserId or DateCreated DESC → then you can verify/update the expiry date
- All registered certificate templates can be found in certificates table. Same template file can be used by different template with different Duration and ShortId