search

bcgov / hcap

Application supporting access to the Health Career Access Program (HCAP) for employers and participants.
Apache License 2.0
2 stars 1 forks source link

HCAP-1345 Add subquery to skip counting duplicate participants #844

Closed arranfw closed 2 years ago

arranfw commented 2 years ago

I missed filtering duplicate participants, I moved from a join to a subquery to properly count hires. The subquery is modeled after https://github.com/bcgov/hcap/blob/dev/server/services/employers.js#L130

https://freshworks.atlassian.net/browse/HCAP-1345

sonarcloud[bot] commented 2 years ago

Kudos, SonarCloud Quality Gate passed!    Quality Gate passed

Bug A 0 Bugs
Vulnerability A 0 Vulnerabilities
Security Hotspot A 0 Security Hotspots
Code Smell A 0 Code Smells

No Coverage information No Coverage information
0.0% 0.0% Duplication