nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom Smart Field - string data type max field size

Dyan Karstens

Hi,
We have a question about the smart field value field size. For custom string/text smart fields, we've noticed that there's a default limitation of 255 characters. Has anyone found a way to adjust this to be larger in the smart field spec? We have a few calculated lists stored in smart fields (as an example - constituency list) and we've had to truncate the results because of the 255 character limit. How has anyone else handled this?

Thanks!

Find more posts tagged with

Comments

Michael Flynt

@Dyan Karstens You are unlikely to solve this one, sorry to say. The length of the string column is not set by a parameter. Even if you extend the length of the value column by altering and reloading the backing tableSpec or by DDL script, the smart field business process creates a temp table set to nvarchar(255). As a consequence you will experience truncation exceptions as longer data are inserted. Short of creating a replacement business process, you are stuck. Perhaps look at other options, like, gulp, attributes.

Dyan Karstens

Thank you @Michael Flynt! I was curious if manually adjusting the field's length would work - good to have that answer.