# Power Table - Default sorting

**URL:** <https://forum.inductiveautomation.com/t/power-table-default-sorting/21182>\
**Category:** Ignition\
**Created:** [December 2, 2018, 11:08pm UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182 "2018-12-02T23:08:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pat.stave1](https://avatars.discourse-cdn.com/v4/letter/p/f19dbf/32.png) [@pat.stave1](https://forum.inductiveautomation.com/u/pat.stave1)\
**Post date:** [December 2, 2018, 11:08pm UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/1 "2018-12-02T23:08:41Z")

</div>

Is it possible to set a “Startup Default Sorting” column on the power table?  
The dataset contains one timestamp column (non-sorted) that i want to sort on.

---

<div class="post-metadata">

**Author:** ![mcgheeiv](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\
**Post date:** [December 3, 2018, 11:29am UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/2 "2018-12-03T11:29:11Z")

</div>

If the data is from a sql query, add an “order by” clause.

---

<div class="post-metadata">

**Author:** ![pat.stave1](https://avatars.discourse-cdn.com/v4/letter/p/f19dbf/32.png) [@pat.stave1](https://forum.inductiveautomation.com/u/pat.stave1)\
**Post date:** [December 3, 2018, 11:48am UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/3 "2018-12-03T11:48:58Z")

</div>

Problem is that the data is not from SQL, byt from an internal dataset.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 3, 2018, 12:48pm UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/4 "2018-12-03T12:48:45Z")

</div>

Use the sortDataset function:

[https://docs.inductiveautomation.com/display/DOC79/sortDataset](https://docs.inductiveautomation.com/display/DOC79/sortDataset)

---

<div class="post-metadata">

**Author:** ![jnqplas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jnqplas/32/4054_2.png) [@jnqplas](https://forum.inductiveautomation.com/u/jnqplas)\
**Post date:** [July 3, 2019, 12:57pm UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/5 "2019-07-03T12:57:38Z")

</div>

I have the same question, but I’m using Tag History on a power table. Would I have to convert to a SQL Query? If that’s the case, I would have to join different partitioned tables based on my start/end date filters, correct?

---

<div class="post-metadata">

**Author:** ![jnqplas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jnqplas/32/4054_2.png) [@jnqplas](https://forum.inductiveautomation.com/u/jnqplas)\
**Post date:** [July 3, 2019, 1:46pm UTC](https://forum.inductiveautomation.com/t/power-table-default-sorting/21182/6 "2019-07-03T13:46:42Z")

</div>

Please disregard. I figured it out.

I applied the system.dataset.sort() to the property change script.

Thanks for your input!