# Finding the column in Power Table when data is entered in Text Field

**URL:** <https://forum.inductiveautomation.com/t/finding-the-column-in-power-table-when-data-is-entered-in-text-field/42191>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [January 13, 2021, 6:47am UTC](https://forum.inductiveautomation.com/t/finding-the-column-in-power-table-when-data-is-entered-in-text-field/42191 "2021-01-13T06:47:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![emrcannaydn](https://avatars.discourse-cdn.com/v4/letter/e/dec6dc/32.png) [@emrcannaydn](https://forum.inductiveautomation.com/u/emrcannaydn)\
**Post date:** [January 13, 2021, 6:47am UTC](https://forum.inductiveautomation.com/t/finding-the-column-in-power-table-when-data-is-entered-in-text-field/42191/1 "2021-01-13T06:47:51Z")

</div>

Hi everyone first of all i’m sorry for my bad english, i have a question, i have power table in my window and i have a textfield, i want to do when i input some values to textfield, see the same values on the power table’s irsaliye\_no’s column and filter the power table.I attach the picture of my components, I hope you understand me thanks for help!

 ![ignition](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/7/47898853eeb021a15ef4fb871a3eea1c1e4d4f26.png)

---

<div class="post-metadata">

**Author:** ![emrcannaydn](https://avatars.discourse-cdn.com/v4/letter/e/dec6dc/32.png) [@emrcannaydn](https://forum.inductiveautomation.com/u/emrcannaydn)\
**Post date:** [January 13, 2021, 10:37am UTC](https://forum.inductiveautomation.com/t/finding-the-column-in-power-table-when-data-is-entered-in-text-field/42191/2 "2021-01-13T10:37:43Z")

</div>

i solved my problem, for solution i changed my power table data’s sql query to this  
SELECT \* FROM izlenebilirlik\_uretim WHERE batch\_no LIKE ‘%{Root Container.Text Field.text}’ then my problem solved i hope it helps you have a good day.