Hornbill How To: Reporting
|
The following is a complete list of the Reporting "How To" guides, hints, tips and videos that have been created to aid in the configuration and usage of the system. |
Related Articles |
Table/Column_Alias
If you happen to create a report that extracts information from different tables such as the Assets, Requests, Asset Types tables, then you would have some fields with the same column names. This in itself is ok except if you are trying to read a report, you would confuse field names. This is where table and field aliases come in.
You could add an alias for a table such as h_cmdb_asset_types simply because the table name is very long and you wish to shorten it for reference elsewhere. You can do this by double clicking on the table name on the Select Tables tab. Then you should see the option to 'Add Alias' or 'Remove Table'
In tables such as h_cmdb_assets you have a column called h_name. Similarly in table h_cmdb_asset_types, you also have a column called h_name so in order to create a report with these two tables, to avoid confusion, you can use field aliases to differentiate between the two fields.
In the illustration, we are using SQL Schema Designer and four tables: h_itsm_requests, h_cmdb_assets, h_cmdb_asset_types and h_cmdb_links.