search

jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
152 stars 28 forks source link

Not Sorting #47

Open kfrancis opened 7 months ago

kfrancis commented 7 months ago

v1.2.9

Simple data set

Not sorting

csvQuerySortIssue

jokedst commented 7 months ago

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 commented 7 months ago

Nice animated gif by the way!

kfrancis commented 7 months ago

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.