Hi All,
The report shown below consists of four different graphs combined together. Here for the first report, the report label is coming as the table name (Incident SLA) and for the other graphs the label is displaying with their respective dataset names which is fine. It is not working in the same way for the first graph.
Here I want to change the label name from Incident SLA to User Time. How can I achieve this functionality?
Regards,
Nasreen
Hi Nasreen,
As i see you have created the database view. Now
Once the database view is created on top of the table on which you wish change the column names while seeing them in a report. Once a database view is defined go in the System Definition> Language File module and create new field records by selecting the Database view in the table section and by providing Element name and label name for the field.
Also, a new property has been introduced in Paris to provide Report Field Aliases (glide.report.enable_alias_config) once set to true will allow users to define aliases on the report itself.
Kindly mark the answer as Correct & Helpful both such that others can get help.
Thanks,
Sandeep
HI
You can create database view and then you can change field values of database view using Language field.
Another Approach is :
Following will change the label in all occurrences and not just for a particular list.
- From Application Navigator, open "sys_documentation.list"
- Find the table to change (e.g. cmdb_ci_linux_server)
- Filter on the language if there are several different languages supported on the system
- Change the value of the Label cell.
- Label in the list should change
Mark my answer correct & Helpful, if Applicable.
Thanks,
Sandeep
Hi Sandeep,
The second approach i.e., changing the label name of the table changes the table name everywhere which is not a feasible solution for this.
Could you let me know in detail how to change the label name of a table just for reporting purpose. I have tried creating a DB view but in that I am unable to find the Incident SLA(incident_sla) table as shown below even though I am able to select incident_sla table in the report.
And after that how to change the label of that table so that it will be visible in the report as User Time instead of Incident SLA.
Regards,
Nasreen
Hi Nasreen,
As i see you have created the database view. Now
Once the database view is created on top of the table on which you wish change the column names while seeing them in a report. Once a database view is defined go in the System Definition> Language File module and create new field records by selecting the Database view in the table section and by providing Element name and label name for the field.
Also, a new property has been introduced in Paris to provide Report Field Aliases (glide.report.enable_alias_config) once set to true will allow users to define aliases on the report itself.
Kindly mark the answer as Correct & Helpful both such that others can get help.
Thanks,
Sandeep
Hi Sandeep,
I am unable to change this property value to true even after elevating my role to 'security_admin'.
Even though I have created a field label, it is still showing Incident SLA as teh table name in the report.
