Alias to DB view columns

[maryc]

Hi,

I have a Database view which contains columns from 4 tables. I have 2 same   columns selected from a table but with different where clause.

I want to change the label of these 2 columns to be different when I run a report. How do I achieve this?

Thanks

[Valor1]

Sure,

Just create a new record on the "sys_documentation" table

I just tried it, filling in these fields, where the "element" is the extended view column name, including prefix:

[maryc]

VAlor,

the 2 columns are the same with 2 diff where clause. Will that work?

[Valor1]

I think that's what I showed you.. In the "alm_hardware_metric" table (which is a join of:

1. metric_definition
2. metric_instance
3. alm_asset

Both the Metric Definition and the Asset table have a column of "sys_class_name" with a label of "Class".

As a result of the above, my form looks like this: