# PerspectiveTable Columns Sort with Dataset

**URL:** <https://forum.inductiveautomation.com/t/perspectivetable-columns-sort-with-dataset/102240>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [February 12, 2025, 11:15am UTC](https://forum.inductiveautomation.com/t/perspectivetable-columns-sort-with-dataset/102240 "2025-02-12T11:15:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edoardo\_Pierini](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@Edoardo\_Pierini](https://forum.inductiveautomation.com/u/Edoardo_Pierini)\
**Post date:** [February 12, 2025, 11:15am UTC](https://forum.inductiveautomation.com/t/perspectivetable-columns-sort-with-dataset/102240/1 "2025-02-12T11:15:00Z")

</div>

I have a Perspective Table bound to a Named Query feeding a Dataset to it and I don't seem able to make columns sortable\editable in any way.

Does binding a Table to a dataset prevent column sorting and other editing of the table? Even resizing the columns seems impossible despite the options being selected.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [February 12, 2025, 12:22pm UTC](https://forum.inductiveautomation.com/t/perspectivetable-columns-sort-with-dataset/102240/2 "2025-02-12T12:22:41Z")

</div>

Two things:

1. Use an ORDER BY clause in your named query SQL to get the default / initial sort order.
2. Set `columns.n.sortable : true` for each column `n`.  
For this (and many of the column properties) to work you need to define the `columns.n.field` property. Set each one to the exact name of the SQL data column. (Case matters.)

---

<div class="post-metadata">

**Author:** ![Edoardo\_Pierini](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@Edoardo\_Pierini](https://forum.inductiveautomation.com/u/Edoardo_Pierini)\
**Post date:** [February 14, 2025, 9:27am UTC](https://forum.inductiveautomation.com/t/perspectivetable-columns-sort-with-dataset/102240/3 "2025-02-14T09:27:36Z")

</div>

Thanks, number 1 was already in place but number 2 was the issue, the column names were placeholders and didn't match the SQL table's