Use cell-value from table in script

[marc.proske]

Hi, i am curious how it is possible to get the value of a specific cell from a table to use it in a script? I need to get the value of the cell in the “ID”-Column from a selected row. Later on i use that value to trigger a db-procedure to delete that entry.

EDIT: Found a solution…pretty easy. If there is a better way let me know

Script:

var members = table1.getSelectedRowHierarchyMembers();
var index = members[0].caption;

[costin.manea]

Hello @marc.proske

Also, you can use this script:
table9.metricSetBindings[0].dataResult.cellset.rows[e.relatedData.rows[0]].members[1].uniqueName.split(’.’)[0]

[marc.proske]

Hi @costin.manea

i think this code is too specific? I get an error. I tried to adjust it, it compiles but at runtime it breaks.

[costin.manea]

@marc.proske the ’ ’ are wrong. I copied the text from a file and I think the format was changed.
With table1 instead table9.