Treat null as zero
When sorting an API request on e.g. totalratingcount descending, I'd expect the highest numbers to be at the start, and games with no ratings to be at the bottom. This is currently not the case, where games with no ratings (null) are at the start. This essentially makes the sorting function broken. Please treat null as zero in the API so that these games appear at the bottom of the response as expected.
6
votes
joekw
shared this idea
-
japnoo
commented
Yup, this is a huge problem.
+1 -
poohbers
commented
Heavy +1.
Adding where rating != null isn't sufficient because legitimate games that haven't been released yet or have no rating get removed from the response. Treating null as zero would fix this issue.