# Extract row column value from perspective table on a 'double click' **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition81, scripting\ **Created:** [April 29, 2022, 7:13pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067 "2022-04-29T19:13:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jeff.ryan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeff.ryan/32/25543_2.png) [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Post date:** [April 29, 2022, 7:13pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/1 "2022-04-29T19:13:58Z")
![Capture2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/5/3573dc8bd0d329ea30c1dd1861a22dbbf7ad18ac.jpeg) I must be close, sorry if this is a simple one; I want to extract the value of a specific column of a row of a table on a Perspective view when it is double - clicked, so I can pass that value as a param to a view that will pop up and display further detail. What is the syntax for line #2 of the attached for extracting that table data (since what is there isn’t doing it)? Thanks much! ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [April 29, 2022, 7:35pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/2 "2022-04-29T19:35:58Z")
Assuming that the props.data is a dataset type the syntax would look like: ```auto RunID = self.data.getValueAt(event.row, "RunID") ``` ---
**Author:** ![jeff.ryan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeff.ryan/32/25543_2.png) [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Post date:** [April 29, 2022, 7:41pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/3 "2022-04-29T19:41:13Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/a/6a8b8f032031675094e7ea06b972690657ad6e2f.png) Hmm, I try that too, and It’s not invoking or getting to the pop up window, ‘bombing’ on the getValueAt, with this error in the logs for the script… ---
**Author:** ![jeff.ryan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeff.ryan/32/25543_2.png) [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Post date:** [April 29, 2022, 7:42pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/4 "2022-04-29T19:42:31Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/a/2adf1352aa73809b1f1eef53c99202ea6eb17b83.png) Ohh, and sorry, yes it is a Dataset. Thanks much! ---
**Author:** ![jeff.ryan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeff.ryan/32/25543_2.png) [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Post date:** [April 29, 2022, 7:48pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/5 "2022-04-29T19:48:25Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ffd6086cadc1d6d2333d22bd91e10d8da22c090e.png) And if it has any bearing, it is bound to a Query… ---
**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Post date:** [April 29, 2022, 7:56pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/6 "2022-04-29T19:56:29Z")
Hi @jeff.ryan, Why are you not using the event.value this give you a json string. Then you can extract the value you need. ---
**Author:** ![jeff.ryan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeff.ryan/32/25543_2.png) [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Post date:** [April 29, 2022, 8:06pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/7 "2022-04-29T20:06:17Z")
@Arnaud_Declerck , lack of familiarity and experience… But now I know. I got there. Thanks to both of you. As I think somehow the GetValueAt would do it. But this is what I need. Thanks. ---
**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\ **Post date:** [April 29, 2022, 8:09pm UTC](https://forum.inductiveautomation.com/t/extract-row-column-value-from-perspective-table-on-a-double-click/59067/8 "2022-04-29T20:09:41Z")
Little correction it's a dict not a string 🙂 Experience comes with time and practice trust me 😉 I few month ago i was asking such questions also. All the best with your project Regards