Change Column Label on Database View

[Stan Martin]

I've created a Database View that joins the Audit Table with the Choice Table.  There are actually 2 separate joins so that I can get the old value and the new value separately.  However, when I display the database view, I have 2 column headers called Label.  I need to have 1 say Old State and the other say New State.

[Maik Skoddow]

Hi @Stan Martin 

labels for the headers of database views are stored at table sys_documentation.

If there are no entries for your database view, the labels from the original tables are taken.

Kind regards
Maik

[Sagar Pagar · Accepted solution]

Hi Stan Martin,

You need to create a new label for that field/column and add your database-view-table-name. It will rename the field/column name in database view.

Please check this docs: Change the field label or hint and thread: Can't relabel a column in a database view

Regards,

Sagar Pagar

[Stan Martin]

Got it.

and for the 2nd label

New labels show up just the way I wanted.

[shallom]

you can rename the column name via sys_documentation 

• Table: database view table
• Field: new database view field