How to Rename fields in APM-UI Configuration
search cancel

How to Rename fields in APM-UI Configuration

book

Article ID: 111889

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

We have displayed the Country field for Location in APM. 
But in the APM GUI the field has a label of "Name" and we need that label to be "Country". 
The same applies to the "Alias" field in "Company Bought For", this should be labeled as "Company Code". 
When we are in the CONFIGURATION : ON editing mode, these field labels are not editable.

We have displayed the Country field for Location in APM. 
But in the APM GUI the field has a label of "Name" and we need that label to be "Country". 
The same applies to the "Alias" field in "Company Bought For", this should be labeled as "Company Code". 
When we are in the CONFIGURATION : ON editing mode, these field labels are not editable.

Environment

Windows

Resolution

MDB manual update:
==================
1 Execute this query
SELECT form_attribute_id,control_type_id,form_id
,attribute_name,attribute_path,class_name,search_formlet
,group_in,visibility,label_format,sort_dirctn_id
,custom_attribute_label,core
FROM al_form_attribute_def
where attribute_name = 'preferredvendor'
OR
select custom_attribute_label,* from al_form_attribute_def WHERE custom_attribute_label is not NULL
OR
select custom_attribute_label,* from al_form_attribute_def 
WHERE custom_attribute_label is not NULL
and (custom_attribute_label like '%and%' or custom_attribute_label like '%Name%')

2 From the result write down the value of the column 'form_attribute_id'(12058 for me).

3a Then execute the following query
select custom_attribute_label,* from al_form_attribute_def WHERE form_attribute_id in (7,18)
3b Next I changed the label-text as follows:
UPDATE al_form_attribute_def SET custom_attribute_label = 'TEST LABEL' WHERE form_attribute_id = 12058

4 Open the APM-UI for the 'model' and confirm the label text changed.