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.
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?
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.
3 Likes
I was able to precisely replicate the sorting problem in a power table using this dataset that datatypes the last column as strings:
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
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]]
5 Likes
Thank u Its working
1 Like