SQL Table editor: doesn't load the correct values when editing

[Marco]

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?

[RobbSalzmann]

Hi Marco, 

The part that matters here is the SQL Table Editor section of the component configuration.  Can you show us that?

[Marco]

Sure.

[RobbSalzmann · Accepted solution]

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])

[Marco]

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.