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
Allen Houchins
10/04/2024, 7:51 PM
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.