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
Solved
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 tables that use the same view to edit information, and each one has a different bound parameter, and that value is assigned in the SQL table editor section.
Example:
As you can see, it's set up in the same way, but where the DItemID value is assigned is where I'm having issues. ¿Any solution to this?
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])
4 Replies
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])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.
Hi Marco,
The part that matters here is the SQL Table Editor section of the component configuration. Can you show us that?
Sure.
