Renaming an "attribute qualifier" of items.xml

[former_member656811]

Renaming an "qualifier" of *items.xml, will it delete the old data of the column from DB. What is the good way to renaming qualifier and impacts.?How internally rename works?

Kindly let me know if you have any idea on this.

[arvind-kumar_avinash]

Hi Dharavath Babulal - You need to follow the steps given below in the specified sequence:

1. define a new attribute in the itemype in items.xml and perform a system update.
2. export data from the old attribute and import it into the new attribute.
3. adjust your code to refer the new attribute and test your application.
4. delete the old attribute from the itemype in items.xml and perform a system update.

At a later point of time, if you want to get rid of the old column and its data in the database table, you will need to remove it using SQL command, something like:

DELETE FROM attributedescriptors WHERE lower(columnName)='your-old-column-name-in-db-table'

However, instead of deleting the old column from DB, I would leave it as it is.

[former_member656811]

For the above point -2 If we rename Qualifier/item type from XXXname to xxxName in items.xml.It will not impact any change on DB.

[former_member656811]

Thank you Arvind Kumar for quick help.

I have two more related questions/approach.

1.If I modify column name in DB first and then same name I give it in items.xml,So will it sync?If so it will reduce the copy old data into new column and etc.

2.even renaming of XXXname to xxxName in items.xml have to follow the same as above or will it follow case sensitive?

Kindly correct me if I am wrong.