CsvQuery icon indicating copy to clipboard operation
CsvQuery copied to clipboard

Not Sorting

Open kfrancis opened this issue 1 year ago • 3 comments

v1.2.9

Simple data set

Not sorting

csvQuerySortIssue

kfrancis avatar Mar 18 '24 13:03 kfrancis

Well, it is sorting. As strings. The windows grid has no clue this column is actually numbers. There is a workaround, if you enable "DetectDbColumnTypes" in the plugin settings, and sort using SQL ("SELECT * FROM THIS ORDER BY 2") then it works.

But that kinda goes against the whole "should just work" that is sort of the guideline of this plugin. Perhaps it's possible to tell the windows grid this is numbers? And DetectDbColumnTypes should perhaps be on by default.

jokedst avatar Mar 19 '24 15:03 jokedst

Nice animated gif by the way!

jokedst avatar Mar 19 '24 15:03 jokedst

Nice animated gif by the way!

https://www.screentogif.com/ - my fav for that.

Right, duh - sorry that makes total sense. That work around works as well, can confirm. I think it just looked like a bug because it appears that it should work but doesn't. Would be nice to have the order by appended when you click the column? Also, while the query works - clicking on the column doesn't ever work.

kfrancis avatar Mar 19 '24 16:03 kfrancis