# Perspective table column sort property

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 27, 2025, 2:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733 "2025-10-27T14:23:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Travis\_Crooks](https://avatars.discourse-cdn.com/v4/letter/t/3da27b/32.png) [@Travis\_Crooks](https://forum.inductiveautomation.com/u/Travis_Crooks)\
**Post date:** [October 27, 2025, 2:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733/1 "2025-10-27T14:23:25Z")

</div>

Does anyone know how to get the sort property for column in perspective tables to work? I tried to find something in the user manual but was not successful. If I change the sort, ascending to none and use the sort icon at the top of the column it sorts just fine. Unfortunately saving the designer like this does not lock the sort in as default. I need the table to be rendered with this column sorted as default. I thought this setting on the column would do that. but it does not appear to do anything when I change it. Or I am missing something important to get it to work.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed5d74e18f21b5d1c8f860fbddd18e6401b48d2b.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/4/a47c7c0f7ca9c5510abe69f90f12a7a1cf257c09.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 27, 2025, 2:30pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733/2 "2025-10-27T14:30:42Z")

</div>

Sort the raw data in your binding.

---

<div class="post-metadata">

**Author:** ![Travis\_Crooks](https://avatars.discourse-cdn.com/v4/letter/t/3da27b/32.png) [@Travis\_Crooks](https://forum.inductiveautomation.com/u/Travis_Crooks)\
**Post date:** [October 27, 2025, 2:48pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733/3 "2025-10-27T14:48:59Z")

</div>

Good call, I used system.dataset.sort() to sort the dataset in code. that did the trick. Still wish I knew how that setting was supposed to work in the designer though.

---

<div class="post-metadata">

**Author:** ![djs](https://avatars.discourse-cdn.com/v4/letter/d/e47774/32.png) [@djs](https://forum.inductiveautomation.com/u/djs)\
**Post date:** [October 27, 2025, 5:26pm UTC](https://forum.inductiveautomation.com/t/perspective-table-column-sort-property/111733/4 "2025-10-27T17:26:03Z")

</div>

You need to use the `sortOrder` property if you want the table to be sorted by default.  
If the columns are specified with the `sort` property defined on them, the table will look at the `sortOrder` property to sort on load. There's examples in the manual:

> **[Perspective - Table | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table#properties)**
>
> The Table component displays database data in tabular form.