Sorting doesn't work correctly

[bryantlin]

Hi, I understand #104 is closed but I find the issue below.

Original sort order:

Column

1 9 12 82 13

After sorting (i.e. clicking the header "Column"), the data looks like:

Column

1 12 13 82 9

Does anyone run into the same problem? Or, am I missing something?

Thanks!

[ccnoecker]

I am also having this issue with version 1.0.2 and Grafana 7, weirdly an old version (0.0.9) on another instance (Grafana 6) still works fine.

[briangann]

strange regression, will take a look

[welyss]

same problem, and I print the columnType with console.log('wys:' + columnType + ',text:' + this.table.columns[i].text); in file DatatableRenderer.ts:429

[aerosadegh]

I have same problem when update datatable panel to last version.

[peterschristoph]

Same here, also the datatype does not matter.

• grafana @ 7.1.5
• briangann-datatable-panel @ 1.0.2

Problem:

• 9
• 5
• 3
• 2
• 2
• 2
• (Next page)
• 2
• 2
• 16
• 1

[ezerog]

It looks like sorting as string. This should be fixed asap.

[anthraxn8b]

Would be great to have this fixed soon... Your plugin is currently my only chance to get CSV in Excel dialect :-)

[hokiepokedad2]

I too have this problem.

[briangann]

in progress, need good sample data to work with to verify though :)

[anthraxn8b]

@briangann, use sample data with numbers ;-)

[aerosadegh]

in progress, need good sample data to work with to verify though :)

The num col in this tabel:

id	num	Country
1	95	Chile
2	883	US
3	79	Indonesia
4	754	Brazil
5	75	Romania
6	73	Turkey
7	61	South-Africa
8	56	Iraq
9	55	Italy
10	53	Czechia

version: 1.0.2 Unit: short ; Decimals: 0

[ezerog]

any plan to resolve?

[briangann]

yes, will prioritize this one along with a couple others over the next few days, thanks!

[ezerog]

When will this be resolved? 😭