Forum Discussion

Marco's avatar
Marco
Contributor II
2 years ago

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...
Dashboards
  • RobbSalzmann's avatar
    RobbSalzmann
    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's avatar
RobbSalzmann
Valued Contributor II
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])

  • Marco's avatar
    Marco
    Contributor II
    2 years ago

    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.