Hello! Is there a way to get Fleet to sort numeric...
# fleet
c
Hello! Is there a way to get Fleet to sort numerical values correctly in the UI? Tried "casting as int" but to no avail. Using Fleet 4.55.1 Query and screenshot attached for reference
Copy code
SELECT pid, name, CAST(ROUND((total_size * '10e-7'), 2) AS INTEGER) AS used 
FROM processes 
ORDER BY used DESC 
LIMIT 10;
a
I was able to replicate this in 4.57.2. Interestingly the pid column sorts correctly so it seems to be something specific to CAST.