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

Nitishkrish16
New Contributor III

Dear Community, 

Nitishkrish16_0-1685035331658.png

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. 

2 ACCEPTED SOLUTIONS

NidhiMangtani
Contributor III

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.

Thanks,
Nidhi Mangtani

View solution in original post

JackLacava
Moderator
Moderator

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.

View solution in original post

4 REPLIES 4

NidhiMangtani
Contributor III

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.

Thanks,
Nidhi Mangtani

Thank you so much! 

JackLacava
Moderator
Moderator

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.

Thank you so much for your response.