I have multiple queries and I would like to set the default alias and description in order to assist my users select the right data. Can this be accomplished through “Metadata datasource properties” or otherwise?
Ideally I want to describe on the schema somewhow what each column represents instead of every query… is that possible?
Hi George,
to set the default alias/description you need to configure the metadata datasource for the report. (there is currently no way to have a global specification that is used for every dynamic list.) The metadata datasource expects as result a table containing three columns,
column name, default alias, default description.
For example, using a mysql datasource you could use a statement such as
SELECT 'TheColumnA', 'Some Default Alias', 'some description' FROM DUAL
UNION
SELECT 'TheColumnB', 'Some Other Alias', 'some description' FROM DUALDoes this answer your question?
Cheers
-Arno