# Sort Functionality **URL:** \ **Category:** Module Development\ **Tags:** ignition80, perspective\ **Created:** [March 30, 2026, 12:17pm UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763 "2026-03-30T12:17:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![kirangodhade](https://avatars.discourse-cdn.com/v4/letter/k/48db29/32.png) [@kirangodhade](https://forum.inductiveautomation.com/u/kirangodhade)\ **Post date:** [March 30, 2026, 12:17pm UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763/1 "2026-03-30T12:17:52Z")
Dear Team , I am using a table for data population; however, the default data sorting functionality is not working for the last column.(Outside additon) Kindly check the attached image and assist in resolving the issue. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/1729d11547b7e4b02fb16945024d5018c7ca2858.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 30, 2026, 3:51pm UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763/2 "2026-03-30T15:51:20Z")
You posted this in the #Module Development category. Is this related to a custom module you're developing, or is this a general Ignition/Perspective question? ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [March 30, 2026, 4:03pm UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763/3 "2026-03-30T16:03:58Z")
I'm guessing those values are stored as text/strings and not numbers. As you can see, it's sorting based on the first digit going from 8 at the top down to 2 and the bottom. Fix the data type and sorting should work. ---
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [April 3, 2026, 4:33am UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763/4 "2026-04-03T04:33:42Z")
> [@michael.flagler](#): > > Fix the data type I was able to precisely replicate the sorting problem in a power table using this dataset that datatypes the last column as strings: ```python headers = [ "HeatId", "Heat End Time", "Unit", "Grade", "Series", "Liquid Fr-Cr (Kg/MT)", "Tap to Time (Mins.)", "VCB Time (Mins.)", "nVCB Time (Mins.)", "Delay (Mins.)", "Total Flux Consumption (Kg)", "Bunker Addition (Kg)", "Outside Addition (Kg)"] data = [ [12600835, "05/03/2026 10:03 pm", "EAF1", "304", "300", 78.01, 83, 57, 26, 0, 3772.0, 2972.0, "800.0"], [12600794, "03/03/2026 05:03 am", "EAF1", "409L", "400", 138.45, 89, 58, 31, 8, 2974.0, 2174.0, "800.0"], [12600795, "03/03/2026 06:50 am", "EAF1", "409L", "400", 51.9, 101, 69, 32, 18, 3104.0, 2304.0, "800.0"], [12600796, "03/03/2026 08:23 am", "EAF1", "409L", "400", 158.5, 87, 54, 33, 10, 3753.0, 2953.0, "800.0"], [22600816, "03/03/2026 04:43 am", "EAF2", "410DB", "400", 131.58, 95, 71, 24, 8, 800.0, 0.0, "800.0"], [22600854, "05/03/2026 08:36 pm", "EAF2", "EN 1.4307", "300", 59.3, 106, 61, 45, 23, 4800.0, 4000.0, "800.0"], [22600855, "05/03/2026 10:09 pm", "EAF2", "EN 1.4307", "300", 62.94, 90, 65, 25, 0, 4300.0, 3500.0, "800.0"], [22600820, "03/03/2026 01:04 pm", "EAF2", "JBS-X", "JBS", 0.0, 117, 90, 27, 11, 7600.0, 0.0, "7600.0"], [22600821, "03/03/2026 03:03 pm", "EAF2", "JBS-X", "JBS", 0.0, 116, 89, 27, 10, 6801.0, 0.0, "6801.0"], [22600819, "03/03/2026 11:00 am", "EAF2", "JBS-X", "JBS", 0.0, 132, 99, 33, 12, 6600.0, 0.0, "6600.0"], [22600834, "04/03/2026 10:25 am", "EAF2", "UNS S32205", "Duplex", 0.0, 121, 86, 35, 0, 6600.0, 0.0, "6600.0"], [12600799, "03/03/2026 01:38 pm", "EAF1", "JBS-X", "JBS", 0.0, 103, 75, 28, 10, 7844.0, 2044.0, "5800.0"], [22600835, "04/03/2026 12:35 pm", "EAF2", "UNS S32205", "Duplex", 0.0, 122, 94, 28, 15, 5800.0, 0.0, "5800.0"], [22600818, "03/03/2026 08:43 am", "EAF2", "JBS-X", "JBS", 0.0, 131, 96, 35, 19, 5000.0, 0.0, "5000.0"], [22600850, "05/03/2026 02:04 pm", "EAF2", "316", "300", 53.62, 93, 74, 19, 4, 3800.0, 0.0, "3800.0"], [22600837, "04/03/2026 04:27 pm", "EAF2", "304", "300", 23.15, 99, 72, 27, 17, 3300.0, 0.0, "3300.0"], [12600817, "04/03/2026 03:33 pm", "EAF1", "304", "300", 0.0, 91, 63, 28, 18, 5740.0, 2940.0, "2800.0"]] ``` I can also confirm that using floats in the last column fixes the sorting issue, so Michael Flagler's advice is the solution to this problem ```python data = [ [12600835, "05/03/2026 10:03 pm", "EAF1", "304", "300", 78.01, 83, 57, 26, 0, 3772.0, 2972.0, 800.0], [12600794, "03/03/2026 05:03 am", "EAF1", "409L", "400", 138.45, 89, 58, 31, 8, 2974.0, 2174.0, 800.0], [12600795, "03/03/2026 06:50 am", "EAF1", "409L", "400", 51.9, 101, 69, 32, 18, 3104.0, 2304.0, 800.0], [12600796, "03/03/2026 08:23 am", "EAF1", "409L", "400", 158.5, 87, 54, 33, 10, 3753.0, 2953.0, 800.0], [22600816, "03/03/2026 04:43 am", "EAF2", "410DB", "400", 131.58, 95, 71, 24, 8, 800.0, 0.0, 800.0], [22600854, "05/03/2026 08:36 pm", "EAF2", "EN 1.4307", "300", 59.3, 106, 61, 45, 23, 4800.0, 4000.0, 800.0], [22600855, "05/03/2026 10:09 pm", "EAF2", "EN 1.4307", "300", 62.94, 90, 65, 25, 0, 4300.0, 3500.0, 800.0], [22600820, "03/03/2026 01:04 pm", "EAF2", "JBS-X", "JBS", 0.0, 117, 90, 27, 11, 7600.0, 0.0, 7600.0], [22600821, "03/03/2026 03:03 pm", "EAF2", "JBS-X", "JBS", 0.0, 116, 89, 27, 10, 6801.0, 0.0, 6801.0], [22600819, "03/03/2026 11:00 am", "EAF2", "JBS-X", "JBS", 0.0, 132, 99, 33, 12, 6600.0, 0.0, 6600.0], [22600834, "04/03/2026 10:25 am", "EAF2", "UNS S32205", "Duplex", 0.0, 121, 86, 35, 0, 6600.0, 0.0, 6600.0], [12600799, "03/03/2026 01:38 pm", "EAF1", "JBS-X", "JBS", 0.0, 103, 75, 28, 10, 7844.0, 2044.0, 5800.0], [22600835, "04/03/2026 12:35 pm", "EAF2", "UNS S32205", "Duplex", 0.0, 122, 94, 28, 15, 5800.0, 0.0, 5800.0], [22600818, "03/03/2026 08:43 am", "EAF2", "JBS-X", "JBS", 0.0, 131, 96, 35, 19, 5000.0, 0.0, 5000.0], [22600850, "05/03/2026 02:04 pm", "EAF2", "316", "300", 53.62, 93, 74, 19, 4, 3800.0, 0.0, 3800.0], [22600837, "04/03/2026 04:27 pm", "EAF2", "304", "300", 23.15, 99, 72, 27, 17, 3300.0, 0.0, 3300.0], [12600817, "04/03/2026 03:33 pm", "EAF1", "304", "300", 0.0, 91, 63, 28, 18, 5740.0, 2940.0, 2800.0]] ``` ---
**Author:** ![kirangodhade](https://avatars.discourse-cdn.com/v4/letter/k/48db29/32.png) [@kirangodhade](https://forum.inductiveautomation.com/u/kirangodhade)\ **Post date:** [April 8, 2026, 10:36am UTC](https://forum.inductiveautomation.com/t/sort-functionality/114763/5 "2026-04-08T10:36:59Z")
Thank u Its working