search

bcgov / ExitSurveyAdmin

The Exit Survey Administration Tool will assist BC Stats in administering the BCPS Exit Survey.
https://www2.gov.bc.ca/gov/content/data/statistics/government/employee-research/exit-survey
Apache License 2.0
3 stars 1 forks source link

Exit Count not sorting as expected #150

Closed karmour closed 3 years ago

karmour commented 4 years ago

Small bug - I noticed that if I sort on the Exit Count field in the ESA, it appears to sort on the first digit before moving on to the second digit, so values of 10 or higher appear in between those with Exit Counts of 1 or 2. Assuming this is because the values are stored as strings instead of integers.

hangler commented 4 years ago

Fixed. The same bug was on Record Count and Employee ID. Basically, they are represented as strings in the database (and so are sorted alphabetically by first character, so "10" comes before "2" because "1" < "2"), but should be sorted as ints (10 > 2).