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