# Powertable search function

**URL:** <https://forum.inductiveautomation.com/t/powertable-search-function/29672>\
**Category:** Ignition\
**Created:** [November 5, 2019, 8:04am UTC](https://forum.inductiveautomation.com/t/powertable-search-function/29672 "2019-11-05T08:04:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RadicalRumin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/radicalrumin/32/11543_2.png) [@RadicalRumin](https://forum.inductiveautomation.com/u/RadicalRumin)\
**Post date:** [November 5, 2019, 8:04am UTC](https://forum.inductiveautomation.com/t/powertable-search-function/29672/1 "2019-11-05T08:04:46Z")

</div>

A few weeks ago I made a CRUD page in Vision and included a “search” functionality. Because the PowerTable is populated with a SQL query binding I made it work by simply changing the where clause on the binding. You choose a column, enter your search criterion and press a search button that changes some properties en refreshes the binding.

I was wondering if there was a better way to do this in Vision. Has anyone ever done something similar before? Any ideas or suggestions?