# How to Get Data from Current Row and Specific Column in a Table?

**URL:** <https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157>\
**Category:** Ignition\
**Created:** [July 30, 2025, 4:55pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157 "2025-07-30T16:55:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [July 30, 2025, 4:55pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/1 "2025-07-30T16:55:33Z")

</div>

Hi,

I have a table, and I want to retrieve data from the current row. However, when I try, it shows me the entire dataset instead of just the data from the current row.

Could you please help me understand how to get the data from the current row and from a specific column?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/6/26f7cb95a332f7d7ffb3e71ee196d0f931013286.png)

Thank you in advance for your help!

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [July 30, 2025, 5:04pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/2 "2025-07-30T17:04:09Z")

</div>

Tables have a `selection.data` property that should contain the data in the selected row(s). Select the column via name from there. (`{this.props.selection.data[0]}['columnName']` or similar)

Your current binding will change EVERY row's background color, is that what you actually want? If you want to change the background of the selected row, adjust the `selection.style` property.

> **[Perspective - Table | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table#selection-properties)**
>
> The Table component displays database data in tabular form.

Also, it's better to use an expression when possible instead of a script transform, unless you need to loop through something.

[Accessing a dataset via expression](https://www.docs.inductiveautomation.com/docs/8.1/platform/expression-language-and-syntax#dataset-access)

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [July 30, 2025, 6:57pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/3 "2025-07-30T18:57:31Z")

</div>

Hi Ryan,  
Thanks for sharing helpful info but i want to change all rows depend on one column “STATUS” value.  
Thanks if you help in this way.

---

<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:** [July 30, 2025, 7:09pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/4 "2025-07-30T19:09:42Z")

</div>

Your problem is still underspecified.

Do you want:

1. When the value of a particular column in any row is something specific, make the whole **row** a certain style
2. When the value of a particular column in any row is something specific, make the **entire table** a certain style
3. When the value of a particular column in a particular row is something specific, make the **entire table** a certain style

Or something else entirely?

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [July 30, 2025, 7:44pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/5 "2025-07-30T19:44:03Z")

</div>

1. When the value of a particular column in any row is something specific, make the whole **row** a certain style

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [July 30, 2025, 7:47pm UTC](https://forum.inductiveautomation.com/t/how-to-get-data-from-current-row-and-specific-column-in-a-table/109157/6 "2025-07-30T19:47:36Z")

</div>

In that case, you'll need to loop through your data BEFORE providing it to the table, and insert style configurations into the row data for the rows that match your criteria.

Create a custom property on the view, and bind your data source to that custom property. From there, bind your table data to that custom property and apply a script transform. The manual has a fast example:

> **[Styling Rows Based on Values | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table/styling-rows)**
>
> This page includes examples detailing different ways to style rows based on values using Script Transforms. Each example accomplishes similiar results through different binding and data types to change the background color of a row or individual...
