A list field shows sys ids instead of actual values

[RonAlmog]

Hello, I created a custom List field in change_request table, named u_environment, referencing a custom table named u_environment.

When selecting several options their names display properly, but when I submit the change request it only shows the name of the first environment chosen, and the rest of the choices are shown as a single 7-character string.

I tried to set the desired field u_name to "Display" at the custom table, to clear the cache and to set u_name as the "Element" field at the Reference List record of u_environment in the sys_ui_list, and nothing works.

Would appreciate any help! 🙏🏻 

[maik1]

The Work notes list field on table incident for example has a max length of 4000.

Maybe you can share a screenshot of the dictionary definition. My guess is it's set to 40.

[Robert H]

Hello @RonAlmog ,

I agree with @maik1  that it looks like a truncation issue because of a length limit. A sys_id has 32 character. Add a comma and 7 characters and you end up with 40.

Can you please submit a record, then go to the context menu > Show XML and look at the value of "u_environment"?

Regards,

Robert

[RonAlmog]

I've set the max length to 4,000, submitted another change request and nothing changed.

Which XML do you want to see exactly? I didn't really understand

[RonAlmog]

Found it:

<u_environment>758004a28d282210192be1443a8ffe8a,1eb0c4a</u_environment>

The sys_id starting with 7580 is of the first environment Selected, Air*****.

[maik_hofmann]

As expected it cuts off after 40 chars. So you need to increase the max size in the dictionary of the field.