DataGrid Widget Selected Row

Question

Hi, 
 I have mocked up data on a DataGrid widget and I want to be able to display/run actions based on the selected row of data. How can I access and update this data? I am not able to add any animations to the widget, so I tried making a script based on the DataGrid.SelectedRow on a data change to display the SelectedRow on a text box but that was never getting shown. I was hoping to at least see what SelectedRow returned besides knowing the data type is a string. My datasource is a json structure. 
 Also, is it possible to update the information in the DataGrid datasource based on actions done on the graphic? I tried to set the datasource by just sending the whole updated json structure as a string but since I need the " character to reference a string in the json structure. I also attempted to send it not as a string but the { character is the start of a multiline comment so that wasn't an option either. 
 Thanks

Richard Köhlerstrand · Accepted Answer

Hi Caroline, are you using the AVEVA DataGrid widget? 
 
 The Aveva Datagrid wiget will use a JSON or CSV formatted input to display data, and as Haval Aziz mention, you can connect the Propery "SelectedRow " to a Custom Property of choice, (datatype string) 
 This will output the data based on your Column delimiter set in properties, and it will update upon selected row change. 
 Just DONT name your custom property " SelectedRow", that will crash OMI for some reason (Version 2023 R2 P01) 
 Put a DataChange on that Custom Property and parse the data row, or use it as you wish, but this will give you the selected data.

DataGrid Widget Selected Row

Top Replies