# \[BUG-15644\] Perspective Table Sorting Rendered Integers correctly? **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [January 22, 2020, 5:46pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523 "2020-01-22T17:46:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![tmahaffey](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaffey/32/30949_2.png) [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Post date:** [January 22, 2020, 5:46pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/1 "2020-01-22T17:46:48Z")
This table was compiled using a script that converted the tag values to string, so at first I thought maybe the table was sorting incorrectly because it was using the ASCII value of the string, or something like that. The specific column is configured so that the field name matches header for the tag so that I can change different propreties like width, or render it as a view and such. But, when I render it as a number, and the number is “value”, it doesn’t improve the sorting. But, When I render the tag to specifically be an integer, it still sorts the data incorrectly: Not sorted: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/ead8a33dbab8cb291c0e2fc75105bf5e99871bfe.png) Sorted high: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/da9f1d4566a689208b7f9cb9009c4b31d3cb11c2.png) Sorted low: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f169a1701fdeeca7eb46e04973a10d8113c796c9.png) Config for yesterday # poll success: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/adcb59dcc5d90b876f533ca46b9cbaabcbcb92cd.png) ---
**Author:** ![derek\_neese](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@derek\_neese](https://forum.inductiveautomation.com/u/derek_neese)\ **Post date:** [March 10, 2020, 2:33pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/2 "2020-03-10T14:33:34Z")
Following also. ---
**Author:** ![paul.longtine](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.longtine/32/10599_2.png) [@paul.longtine](https://forum.inductiveautomation.com/u/paul.longtine)\ **Post date:** [April 9, 2020, 5:13pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/3 "2020-04-09T17:13:27Z")
I’m seeing this as well. ---
**Author:** ![mlatour](https://avatars.discourse-cdn.com/v4/letter/m/e95f7d/32.png) [@mlatour](https://forum.inductiveautomation.com/u/mlatour)\ **Post date:** [May 1, 2020, 6:43pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/4 "2020-05-01T18:43:01Z")
I’m also seeing this. Did Inductive every respond? Is this getting fixed in an upcoming revision? The sorting in general seems like it’s very flaky and needs some work. ---
**Author:** ![tmahaffey](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaffey/32/30949_2.png) [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Post date:** [May 4, 2020, 10:04pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/5 "2020-05-04T22:04:46Z")
I spoke with tech support about this issue in April. He said it’s a known issue and they were supposed to have fixed over this last patch. But were are on 8.12 and it is still sorting incorrectly. Very flaky indeed. ---
**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Post date:** [May 5, 2020, 2:14pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/6 "2020-05-05T14:14:22Z")
8.0.12 ended up having to be pushed out with an emergency bug fix if I recall. So it likely got bumped to 8.0.13 if 8.0.12 was the version it was going to be updated in, but I haven’t followed the patch notes to know for sure. ---
**Author:** ![321liftoff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/321liftoff/32/27544_2.png) [@321liftoff](https://forum.inductiveautomation.com/u/321liftoff)\ **Post date:** [June 2, 2020, 1:17pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/7 "2020-06-02T13:17:11Z")
> [@tmahaffey](#): > > When I render the tag to specifically be an integer, it still sorts the data incorrectly In your column properties of the Table, if you change the numberFormat to "none" as below, does that help. That seem to be what I have to do to get numbers to sort correctly. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/98cfbc819243fc2d93dbd02f6eb678d2e491c9ef.png) Also, the issue was mentioned here: > [@\[Bug-15644\]Table sorting not working on numeric columns](http://forum.inductiveautomation.com/t/bug-15644-table-sorting-not-working-on-numeric-columns/30245/3): > > We are aware of the issue and have an open ticket to fix the sorting, though there is no time estimate for when the ticket will be begun. ---
**Author:** ![lramos](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@lramos](https://forum.inductiveautomation.com/u/lramos)\ **Post date:** [March 12, 2021, 3:43am UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/8 "2021-03-12T03:43:56Z")
I can confirm this works! ---
**Author:** ![Ahmed\_Cetiner](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Ahmed\_Cetiner](https://forum.inductiveautomation.com/u/Ahmed_Cetiner)\ **Post date:** [September 27, 2023, 3:57pm UTC](https://forum.inductiveautomation.com/t/bug-15644-perspective-table-sorting-rendered-integers-correctly/31523/9 "2023-09-27T15:57:20Z")
This worked for me. My Ignition version is 8.1.1.