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 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?

 

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.

       

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Hi Marco, 

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