Related List showing sys_id in filter where there should be none

Nya Valdez1
Tera Contributor

Hello SN Community, 

I have a custom related list with a default filter, that is showing a sys_id and I can't figure out where it is coming from.  There is no relationship created for this related list, it's strictly coming from the "System UI --> Related List" on the table for the form I'm building. I am posting screenshots to show the filter on the related list entry and also what is appearing on the form. Can anyone please tell me how to remove the sys_id from the filter?

Related List entry:find_real_file.png

What appears on the form:

find_real_file.png

 

 

 

1 ACCEPTED SOLUTION

Anil Lande
Kilo Patron

Hi,

There must a field on your Location table referring to your parent table. It create relationship between Location and parent table. When you add that related list on Parent table form it get default filter. As this is based on reference field it uses displayValue in in filter.

If display value is not defined then it takes sys_id of record in filter.

Please check/change display value of your table, it will display that label instead of sys_id.

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

2 REPLIES 2

Anil Lande
Kilo Patron

Hi,

There must a field on your Location table referring to your parent table. It create relationship between Location and parent table. When you add that related list on Parent table form it get default filter. As this is based on reference field it uses displayValue in in filter.

If display value is not defined then it takes sys_id of record in filter.

Please check/change display value of your table, it will display that label instead of sys_id.

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Thank you so much - I set the display value to true and that resolved the issue.