Fixes the query join in the export self assessment to Excel data method to ensure correct results are returned. Reinstates the clear selection JavaScript that was mistakenly removed in a previous PR. Other problems reported related to missing CompetencyAssessmentRolRequirements records for the duplicate self assessment which were addressed with a script run on UAT DB.
Screenshots
Developer checks
(Leave tasks unticked if they haven't been appropriate for your ticket.)
I have:
[x] Run the formatter and made sure there are no IDE errors (see info on Text Editor settings to avoid whitespace changes)
[ ] Written tests for the changes (accessibility tests, unit tests for controller, data services, services, view models, etc)
[x] Manually tested my work with and without JavaScript
[ ] Tested any Views or partials created or changed with Wave Chrome plugin and addressed any valid accessibility issues
[ ] Updated/added documentation in Confluence and/or GitHub Readme. List of documentation links added/changed:
[ ] Updated my Jira ticket with information about other parts of the system that were touched as part of the MR and have to be sanity tested to ensure nothing’s broken
[x] Scanned over my pull request in GitHub and addressed any warnings from the GitHub Build and Test checks.
JIRA link
TD-4950
Description
Fixes the query join in the export self assessment to Excel data method to ensure correct results are returned. Reinstates the clear selection JavaScript that was mistakenly removed in a previous PR. Other problems reported related to missing CompetencyAssessmentRolRequirements records for the duplicate self assessment which were addressed with a script run on UAT DB.
Screenshots
Developer checks
(Leave tasks unticked if they haven't been appropriate for your ticket.)
I have: