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
Marco
2 years agoContributor II
SQL Table editor: doesn't load the correct values when editing
Hi everyone.
I have the issue that when clicking on a row in an SQL table editor, it doesn't open the view with the correct value, but instead, it displays the value from another table. I have 4 ta...
- 2 years ago
try adding: AND ItemID = '|!param_ALMEC_SItemID!|' to the end of your where clause
(Change ItemID to the name of the column that has the value that corresponds with the parameter if its not [ItemID])
RobbSalzmann
2 years agoValued Contributor II
try adding: AND ItemID = '|!param_ALMEC_SItemID!|' to the end of your where clause
(Change ItemID to the name of the column that has the value that corresponds with the parameter if its not [ItemID])
- Marco2 years agoContributor II
Hello Robb, I've identified my issue. When clicking a row in any table, it's sending information from the other tables as well. Do you know a way to validate and send only the relevant data? And I'll show you that the tables are together in the same dashboard.
Related Content
- 1 year ago
- 2 months ago