# How to filter a table depending on row content?

**URL:** <https://forum.inductiveautomation.com/t/how-to-filter-a-table-depending-on-row-content/14884>\
**Category:** Ignition\
**Tags:** ignition79, scripting\
**Created:** [July 25, 2017, 9:15pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-a-table-depending-on-row-content/14884 "2017-07-25T21:15:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wfallon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wfallon/32/3773_2.png) [@wfallon](https://forum.inductiveautomation.com/u/wfallon)\
**Post date:** [July 25, 2017, 9:15pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-a-table-depending-on-row-content/14884/1 "2017-07-25T21:15:01Z")

</div>

Hi,

I have a table that I want to only show 1 row per hour of data from tag history of a UDT. The tag history logs a lot more times then once per hour, but if I grab the oldest value in the hour chunk it should work. What is the best way of doing this?

Thanks,

Will

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [July 26, 2017, 12:53pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-a-table-depending-on-row-content/14884/2 "2017-07-26T12:53:22Z")

</div>

You can bind a new GUI property to the history table and then set a listener on the property change of that new GUI property to extract one row and display it somewhere else (another table, or split it up in different fields).

---

<div class="post-metadata">

**Author:** ![Caleb\_Bohon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/caleb_bohon/32/3293_2.png) [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\
**Post date:** [July 31, 2017, 5:58pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-a-table-depending-on-row-content/14884/3 "2017-07-31T17:58:27Z")

</div>

Will,

I think you want to get multiple hours of data, right?

It would probably be best to query the history directly in the table.

Here is the relevant page in the documentation:

[https://docs.inductiveautomation.com/display/DOC79/Tag+Historian+and+Tables](https://docs.inductiveautomation.com/display/DOC79/Tag+Historian+and+Tables)