Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,832
Community Members
 
Community Events
165
Community Groups

Attribute size

We are planning to store additional user's attributes in Crowd. The max size for the attribute in Crowd right now is only 255 characters. We need to store up to 2000 characters. I updated the DB table and Crowd seems accept the attribute with larger size fine.

alter table cwd_user_attribute modify (attribute_value varchar2(2000));

alter table cwd_user_attribute modify (attribute_lower_value varchar2(2000));

Only a small number of users will have this attribute so I'm not concerning about performance hit. Will this change cause an upgrade issue later on? Are those attributes going to get truncated back to 255 chars.

1 answer

I believe we will not have problems regarding the column types, however we cannot guarantee that changes in the database model will occur on the newest versions, which can truncate your data. Even though you can perform the customizations, and bear in mind that that some manual procedures will be necessary during the upgrade process to avoid loss of data on those columns.

Cheers!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

225 views 0 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you