user_title increase character length for a field in User entity/table.

Hello,

I increased the character length for user_title field from 50 to 100 and by doing so the system picked up the changes made and my field is now showing 100 character length. However, after metadata refresh the field is still limited to 50 characters only even when it says 100.

Is it hard-coded or am i doing something wrong? Any suggestion are welcome.

Thank you.

  • 0

    Hi Michal,

    You can increase the character length for user_title field. Please refer below steps.

    1) First you need to alter Users table by using below query

    Alter table users

    Alter column user_title nvarchar(100)

    2) After this you need to update Custom_Edit table, as by default CRM created entry for every user field. Make sure value for column ColP_ColPropsId should be unique and it is as per your database. In my database it is 682 so you need to check at your database and use that only.

    select * from Custom_Edits where ColP_Entity='Users' and ColP_ColName='user_title'

    update Custom_Edits set ColP_EntrySize='100', ColP_DataSize='100' where ColP_Entity='Users' and

    ColP_ColName='user_title' and ColP_ColPropsId=682

    3) Once you are done with the same then perform metadata refresh.

    Hope this helps!

    Regards,
    Dinesh