Sorting a table by Int or Double column sorts them as a string

Markus Halttunen shared this problem 6 years ago
Solved

1. Query a collection that contains integer or double values that differ from each other by an order of magnitude (e.g. 4, 14, 300)

2. Show results as "Table"

3. Sort the column

What should happen: The rows are sorted based on the numeric value, e.g. 4, 14, 300

What happens instead: The rows are sorted like the values were strings, e.g. 14, 300, 4

Replies (2)

photo
1

Thank you for your feedback.

We have worked out a new test build to resolve the issue, please download and give it a try.

Mac OS: https://nosqlbooster.com/s3/download/releasesv4/nosqlbooster4mongo-4.5.5.dmg

photo
1

The link pointed to the wrong file but the fix works. Thanks!

Leave a Comment
 
Attach a file