Issue with Contains and Starts With Filter Conditions on Reference Fields in ServiceNow List View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
Hello @armanoj ,
The direct approach you can use is Use the List Column Search (Wildcards) :
-> type *John as asterisk forces a "contains" search at the database level
OR
Your issue might be due caused by a failing query_range ACL.
Refer this :
If my response helped mark as helpful and accept the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
John as asterisk forces a "contains" search at the database level
its not working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Please check whether a Query Range (query_range) ACL exists for the custom table. I suspect that there is currently no query_range ACL configured for this table.
If one does not exist, please create a Query Range ACL for the specific table and assign the necessary roles to it.
