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

Question

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.

NidhiMangtani · Accepted Answer

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.

JackLacava · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded