The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

IBK's avatar
IBK
New Contributor III
2 years ago
Solved

SQL Table Editor column value other than the bound column

I have SQL Table Editor with about 70 columns. I have the bound column tied to a parameter. But I need to access the value of another column of the selected row based on a button click. I want to pro...
dashboards
  • SeanV's avatar
    SeanV
    2 years ago

    Set the Bound column to a column that is a unique identifier for the data record.   Then in the business rule use that unique identifier and SQL to lookup the other fields/values that you need for that record.

  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    Then in your rule, use something like the following to get the row (assuming its always one row) that has the value in it you're looking for:

    Dim uniqueID As String = args.NameValuePairs.XFGetValue("UniqueID", String.Empty)
Dim lstEditedDataRows As List(Of XFEditedDataRows) =  args.SqlTableEditorSaveDataTaskInfo.EditedDataRows
Dim btnClickUserRow As XFEditedDataRow = lstEditedDataRows.Where(Function(row)row.ModifiedDataRow.Item("UniqueID").Equals(uniqueID)).ToList().First()

     

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

Then in your rule, use something like the following to get the row (assuming its always one row) that has the value in it you're looking for:

Dim uniqueID As String = args.NameValuePairs.XFGetValue("UniqueID", String.Empty)
Dim lstEditedDataRows As List(Of XFEditedDataRows) =  args.SqlTableEditorSaveDataTaskInfo.EditedDataRows
Dim btnClickUserRow As XFEditedDataRow = lstEditedDataRows.Where(Function(row)row.ModifiedDataRow.Item("UniqueID").Equals(uniqueID)).ToList().First()