List view unable to filter out field using contains and start with

armanoj
Mega Sage

2 hours ago

Hi @all,

I'm facing an issue with the list view filter for the Reviewer field, which is a reference field pointing to the User table.

When I try to filter records using an existing user's name in the Reviewer field:

  • The is condition works as expected and returns the matching records.

  • However, the contains and starts with conditions do not return any results, even when the user's name exists in the records.

Has anyone encountered a similar issue or know why these filter conditions are not working for a reference field?

0 Helpfuls
  • 50 Views
1 REPLY 1

Rafael Batistot
Mega Patron

3m ago

Hi @armanoj 

 

Reference fields store the user's sys_id, not their name. The is operator performs an exact reference match, while contains and starts with may not work as expected.

 

Try dot-walking to the referenced field, for example, Reviewer.Name contains John.

 

If this response was helpful, please mark it as Helpful and, if applicable, as Correct.
This helps other users find accurate and useful information more easily
0 Helpfuls