# Perspective table query

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-query/44423>\
**Category:** Ignition\
**Tags:** ignition80, perspective\
**Created:** [March 12, 2021, 6:43pm UTC](https://forum.inductiveautomation.com/t/perspective-table-query/44423 "2021-03-12T18:43:33Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [March 12, 2021, 7:07pm UTC](https://forum.inductiveautomation.com/t/perspective-table-query/44423/2 "2021-03-12T19:07:34Z")

</div>

To fix the table column order go to the table _PROPS_, _columns_, and set the _field_ name for column 0 to “In\_time” and column 1 to “Out\_time”. You must use capital letters exactly as returned by the query.

For background colours see if the answers to my similar question help. [Perspective Table - Invididual Cell Conditional Formatting](http://forum.inductiveautomation.com/t/perspective-table-invididual-cell-conditional-formatting/39371).

---

_[View the full topic](https://forum.inductiveautomation.com/t/perspective-table-query/44423)._