Rename entitlement Customproperty labels

[BalajiEpari]

Hi Team,

We need to change entitlement customproperty labels. I am able to change labels from CP1 to CP5 using below path. 

Admin->endpoint->entitlementType

In entitlementType, It don't have entries for Customproperty6,7,8....

How can we achive this?

Regards,

Balaji Epari

[rushikeshvartak]

Run update query on  respective entitlement_types table , its not available from UI

update entitlement_types where set customproperty6_label=‘test’ where entitlementtypekey=1 ;

[BalajiEpari]

Hi @rushikeshvartak 

We are on V23.8, Customquery functionality is not there for query execution. is there any alternative?

Regards,

Balaji epari

[Dhruv_S · Accepted solution]

Hi @BalajiEpari 

assign ROLE_UIADMIN to a user and login with that user. Navigate admin>identity repository>security system>endpoints>navigate to other attributes>Click on the pencil icon to edit the respective custom property labels -CP6,CP7 etc.

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[rushikeshvartak]

Use enhanced query

SELECT 'CP6' AS entitlement_types__customproperty6_label, et.entitlementtypekey as entitlement_types__PRIMARYKEY FROM entitlement_types et where et.entitlementtypekey = 123;

[angela]

If you put yourself in SAV role ROLE_UIADMIN you should have the ability to update the names directly on the page

There is now enhanced custom query job you could use but the query format is different. However, in 23.8 there is a bug that inserts the text in all caps regardless of what you put

SELECT 'cp1' AS entitlement_types__customproperty6_label, et.entitlementtypekey as entitlement_types__PRIMARYKEY FROM entitlement_types et where et.entitlementtypekey = 123;