Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
10/20/2023 04:20 AM
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
Solved! Go to Solution.
10/20/2023 04:22 AM - edited 10/20/2023 04:23 AM
Run update query on respective entitlement_types table , its not available from UI
update entitlement_types where set customproperty6_label=‘test’ where entitlementtypekey=1 ;
10/20/2023 05:23 AM
We are on V23.8, Customquery functionality is not there for query execution. is there any alternative?
Regards,
Balaji epari
10/20/2023 05:39 AM
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.
10/22/2023 06:53 PM
Use enhanced query
SELECT 'CP6' AS entitlement_types__customproperty6_label, et.entitlementtypekey as entitlement_types__PRIMARYKEY FROM entitlement_types et where et.entitlementtypekey = 123;
10/20/2023 05:32 AM
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;