Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
5 years ago

Does anyone know how I can use XFSqlTableEditorSaveDataTaskInfo?

Originally posted by Cosimo Palmisano 7/19/2018 I've got a SQL Table Editor component in a dashboard that queries an SQL View that outer joins two tables. The user can update some fields in a rec...
Dashboards
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
5 years ago
Originally posted by Celvin Kattookaran

think you can loop through all editedrows
For Each modRow As XFEditedDataRow In saveDataTaskInfo.EditedDataRows

brapi.ErrorLog.LogMessage(si, modRow.ModifiedDataRow.Item(""columname"").ToString)

Next

You cannot update a view you need to update underlying tables. It works fine for me if I update the data from a table.