Forum Discussion

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
2 years ago
Solved

Is the "Result Table Name" in the Data Adapter while running a SQL query accessible?

Dear Community, 

In the above image "Results Table Name" located in the Data Adapter for a SQL Query is accessible? The Data Adapter still runs even though if we aren't giving any table name in the alias. Is it only for the naming convention? Or whether it's accessible/stored in the Application Database Tables/System Database Tables under System tab? Any solution to this will be really helpful. Thanks. 

Dashboards
Reports

4 Replies

Sort By
  • JackLacava's avatar
    JackLacava
    Community Manager
    2 years ago
    Copy Link

    To add some context: the Results Table Name is useful in situations:

    • where the DataSet contains multiple tables. This is obviously not possible with simple adapters but it can be done with Dashboard DataSet Rules.
    • when multiple adapters are attached to the same Component, typically BI Viewer and the Report Component, to differentiate between them. That's done using the Result Table Name, otherwise each adapter shows up with a generic name ("Table1", "Table2", etc).

    But yes, it is optional.

  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    2 years ago
    Copy Link

    Hi,

    Its optional to give Results Table Name in data adapter query, if you want the result set to have a custom table name, you can specify here or feel free to keep it blank.

    Hope this helps.