A list field shows sys ids instead of actual values

RonAlmog · ‎03-31-2025

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! 🙏🏻

Robert H · ‎03-31-2025

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

View solution in original post

RonAlmog · ‎03-31-2025

I did, and I still get the same result.

maik1 · ‎03-31-2025

After increasing the field length, a change to the fields selected values should show the desired result. Otherwise please share a screenshot of the dictionary entry for the field so we can further troubleshoot.

RonAlmog · ‎03-31-2025

There it is

maik1 · ‎03-31-2025

And what is the result if you create a new record and select a couple of values in the list and save it? What does the XML show for the list field?

RonAlmog · ‎03-31-2025

It shows the same as beforehand - the sys_id of the first option (32 characters), a comma and 6 characters which are the start of the sys_id of the second option.