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]

I tried to reproduce this on my PDI (Xandau) by creating the list field in various ways and switching field types. I managed to get the default length of 40 when first creating it as a string and then switching to list but it still just worked fine on selection.

Any chance you recall how you created the field?

Did you try to create a new list field?

[Robert H · Accepted solution]

Hello @RonAlmog ,

I did some testing. The Max length attribute is indeed ignored for List fields. I created a new field and deliberately set the Max length to 40 characters but it still works fine even after submitting a record:

Can you please right click on the label of your Environment field, select "Show u_environment" and provide a screen shot of the popup.

Would it be possible for you to create another List field on Change Request that references the Environment table, and check if you have the same issue there?

Regards,

Robert

[RonAlmog]

Attached the pop-up box.

In the new list field on Change Request, should I leave it at max length 40 or immediately change it to 4,000?

[Robert H]

Hello @RonAlmog ,

Thank you for the screen shot. Everything looks normal. This is interesting. I assume there you have already checked if there any Client Scripts or Business Rules or similar logic that might be manipulating that field?

When creating the new field for testing the max length should not matter at all as per my tests. But best if you simply don't touch the value.

Regards,

Robert

[RonAlmog]

Updating that I've created a new List field with max length 4,000 and it works just fine.

Thanks a lot!