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

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.