Custom Smart Field - string data type max field size

Dyan Karstens
Dyan Karstens
Tenth Anniversary Name Dropper Facilitator 1 Loyalty Badge
in Blackbaud CRM™ General Discussions

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!

Comments

  • Michael Flynt
    Michael Flynt
    Second Anniversary Name Dropper Facilitator 1

    @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
    Dyan Karstens
    Tenth Anniversary Name Dropper Facilitator 1 Loyalty Badge

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

Categories