Extending the modeled attribute string length well beyond 500 charater limit

Forum|Forum|10 years ago
July 17, 2015
4 replies
5743 views

Has anyone done this? I have a request that a document type be transferred into Windchill (essentially getting rid of the document by not having primary content), the content would be entered as attributes. The question is, has anyone done anything like this? One of the attribute strings would need to be increased to allow 4-5 thousand characters.

Other

Best answer by BineshKumar1

We have increased an attribute to hold 1000 characters, however never tried to hold the contents of entire document.

We followed the method mentioned in Customizing Column Length .

Thanks

Binesh Kumar

Barry Wehmiller

B

BineshKumar1

Answer

1-Visitor

We have increased an attribute to hold 1000 characters, however never tried to hold the contents of entire document.

We followed the method mentioned in Customizing Column Length .

Thanks

Binesh Kumar

Barry Wehmiller

B

BjoernRueegg

17-Peridot

The max is 4000 characters.

G

GregOlson

Author

16-Pearl

Is there any downside to doing this? You have fully tested this and running in production?

B

BjoernRueegg

17-Peridot

I just said that the max is 4000 characters. You won' t be able to set the size to 5000. We run this also in production mode.

I still hope that finally a WYSIWYG arrives. Then you can also document the changes etc. in a change object itself! I would love to see that!

G

GregOlson

Author

16-Pearl

Do you need InfoModeler to change the database?

B

BenPerry

15-Moonstone

Greg Olson,

According to my experience, and Guilherme Rocha‌, InfoModeler is no longer required. I would've needed it in 9.1. But it worked without InfoModeler when I tried in 10.2.

We can refer to this discussion: 80 character limit.

G

GregOlson

Author

16-Pearl

Ben, does your testing confirm the below situation?

Increasing the character length will involve making changes to the StringValue database table. The catch in this is that all the string valued attributes across Windchill are stored in this table. Increasing the character limit on this table to 4k, would mean we are increasing the character limit for all the string attributes in Windchill to 4k – which would be an undesired condition. So to control the length of all the other string attributes suppose we introduce a character limit of 500 on them. But this might have some performance impact because then Windchill will have to apply the limit validation to all those strings before displaying them on the screen. In short we the situation will be that all the string attributes in the system will be of 4k length, and excepting one or two, we are putting a limit on all the others to limit them to 500.