# Remove filter and show all row in power table when refresh power table

**URL:** <https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 20, 2023, 1:03pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267 "2023-06-20T13:03:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [June 20, 2023, 1:03pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267/1 "2023-06-20T13:03:14Z")

</div>

Hi,

I have power table. i have applied filter in one column. But i want to show all column when table refresh or when switching tabs

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7ab055f3e394e847edc47aad11b8ca08708285e0.png)

filter is not removing  
how to remove filter through scripting?

---

<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:** [June 20, 2023, 1:24pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267/2 "2023-06-20T13:24:27Z")

</div>

> [@Programmatically-applied PowerTable Filters](https://forum.inductiveautomation.com/t/programmatically-applied-powertable-filters/15495/2):
>
> model = self.getTable().getModel().getActualModel() from com.jidesoft.grid import SingleValueFilter class newFilter(SingleValueFilter): def isValueFiltered(self, value): return True if value == target.data.getValueAt(row, 4) else False model.addFilter(3, newFilter()) model.setFiltersApplied(True) model.refresh() I’ve used this code before to successfully apply a filter (shows the filter icon in the table header correctly), and it also allows it to be removed by select…

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [June 20, 2023, 1:37pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267/3 "2023-06-20T13:37:00Z")

</div>

This works:

```auto
powerTable = event.source.parent.getComponent('Power Table')#or other relative path
powerTable.table.model.actualModel.setFiltersApplied(False)

```

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [June 20, 2023, 1:44pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267/4 "2023-06-20T13:44:30Z")

</div>

Its working but icon is still visible

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/d/4d7b3937758e1d5223715d83fa489f330af8bc2c.png)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [June 20, 2023, 2:05pm UTC](https://forum.inductiveautomation.com/t/remove-filter-and-show-all-row-in-power-table-when-refresh-power-table/75267/5 "2023-06-20T14:05:50Z")

</div>

> [@prasath.t](#):
>
> icon is still visible

adding clearFilters works for removing the icons

```auto
powerTable = event.source.parent.getComponent('Power Table')#or relevent path
powerTable.table.model.actualModel.setFiltersApplied(False)
powerTable.table.model.actualModel.clearFilters()

```