# To Delete a selected row in Perspective using a icon

**URL:** <https://forum.inductiveautomation.com/t/to-delete-a-selected-row-in-perspective-using-a-icon/90340>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [May 14, 2024, 4:21am UTC](https://forum.inductiveautomation.com/t/to-delete-a-selected-row-in-perspective-using-a-icon/90340 "2024-05-14T04:21:28Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 14, 2024, 7:23am UTC](https://forum.inductiveautomation.com/t/to-delete-a-selected-row-in-perspective-using-a-icon/90340/10 "2024-05-14T07:23:45Z")

</div>

First understand the parent and child relationships. In your other quesiont, [refreshBinding not working probably because not called on the right object - #10 by Transistor](https://forum.inductiveautomation.com/t/refreshbinding-not-working-probably-because-not-called-on-the-right-object/60172/10), you have the structure,

```python
root
  + Flexcontainer
    + Button
  + Table

```

So, to get from Button to Table you have to go `parent` (which takes you to Flexcontainer) then you use `getSibling` to get to Table.

Alternately, you could go `parent.parent` which takes you to `root` and then use `getChild` to get to Table.

If we examine your code below we can see that you have been inconsistent with the relative paths and they are very deep. You can avoid errors if you use the Property Inspector to create the paths for you as shown by Ujwal in the previous question.

```python
def runAction(self, event):
	row_id = self.parent.parent.parent.parent.parent.getChild("Table").selection.selectedRow
	row = self.getSibling("Table").props.data.pop(row_id)
	system.db.runNamedQuery("Delete_Rows", parameters=row)
	
	self.parent.parent.parent.parent.parent.getChild("Table").refreshBinding("props.data")

```

* * *

**Other problems**

1. Where did you find documentation on using `pop` on a table properties? I can't find it anywhere.

2. To delete a row `WHERE id = :id` you need to retrieve the `id` value from the selected row. Your screengrab doesn't show that column. Maybe you have called it `row_id` but haven't shown it.

3. `runNamedQuery` expects a dictionary of parameters. You haven't supplied one.

4. We don't know the relative paths between your components. Please add a screengrab from Project Browser showing the relative positions of the delete button and the table.

5. Add the `id` column to your table if it is not there already. Show that in a screengrab.

---

_[View the full topic](https://forum.inductiveautomation.com/t/to-delete-a-selected-row-in-perspective-using-a-icon/90340)._