# How to refresh Power Table?

**URL:** <https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126>\
**Category:** Ignition\
**Created:** [March 31, 2021, 4:38pm UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126 "2021-03-31T16:38:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [March 31, 2021, 4:38pm UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126/1 "2021-03-31T16:38:34Z")

</div>

Hi All  
I wonder what might be the reason that power table does not refresh after selecting a row and deleting the entry? The only way to refresh table is to change screens which is not good.  
I have my own project but delete button is base on tutorial documentation and named query.  
[https://docs.inductiveautomation.com/display/DOC80/Simple+Database+Editor](https://docs.inductiveautomation.com/display/DOC80/Simple+Database+Editor)  
system.db.refresh(event.source.parent.getComponent(‘Power Table’), “data”)

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 31, 2021, 4:54pm UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126/2 "2021-03-31T16:54:00Z")

</div>

Is this Vision or Perspective?

One option for both is to set the query to polling.

`system.db.refresh` is used to refresh SQL bindings in Vision. Your data property has the SQL Query binding? If not, this won’t work.

To refresh in Perspective, you need to do something like `self.refreshBinding("props.data")` where self is the table itself. Whatever your chain is to the table, might be something like `self.parent.getSibling()....getSibling("Power Table").refreshBinding("props.data")`.

Again though, make sure you are refreshing whatever actually has the SQL binding. If your table data property (in vision) is not a SQL query, then you must do the `system.db.refresh()` on whatever has the SQL Query binding that your table.data is pointing to.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 31, 2021, 6:14pm UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126/3 "2021-03-31T18:14:20Z")

</div>

> [@bkarabinchak.psi](#):
>
> `system.db.refresh` is used to refresh SQL bindings in Vision. Your data property has the SQL Query binding? If not, this won’t work.

Despite the truly terrible namespace, `system.db.refresh` in Vision will re-evaluate _any_ binding, not just query bindings. Same for `refreshBinding()` in Perspective; while it generally makes the most sense for query bindings, any binding type can be refreshed.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 31, 2021, 6:50pm UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126/4 "2021-03-31T18:50:36Z")

</div>

I understand that refresh can be used on any binding. What I meant was for situations like I have where I have a tree component, and an invisible table component (used for the `.propertiesLoading` so I can show when the tree is being refreshed visually). The tree items are a property reference to the table data. When I was newer to Ignition, to refresh the tree initially what I had done was `system.db.refresh("Tree", "items")`, however what I needed to do was `system.db.refresh("Table", "data")` to refresh the Tree items.

---

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [April 1, 2021, 10:10am UTC](https://forum.inductiveautomation.com/t/how-to-refresh-power-table/45126/5 "2021-04-01T10:10:19Z")

</div>

Thanks for great help. Now i understand why it did not work - i had a query behind opening screen and also behind the button to populate the power table but nothing connected to the data property. Since i added “select from the view…” to the data property even if its not polling at all the power table data is refreshed properly after deleting the row.  
I am happy 🙂