Hello all,
I have come across a strange problem with "keywords" searching on the list.
Scenario:
The table is customer_contact, child of the sys_user table.
As an admin, I am can search with "for text" feature and I will get results.
When I switch to non-admin, doing the same search will return no results.
I thought it is the ACL problem, but this is not the case. When I search specifically in first_name or last_name, the results are shown. It is only the keywords/text search which does not return anything for non-admins.
I thought that the keywords search works with text_indexes, so how come admins have result and non-admin not?
Thank you for your suggestions
Once check in system properties for 'Text Search' and 'Global Text Search'.
Original Query:
Did you ever find a solution for this? Years later, I’m encountering a very similar issue.
Issue Description:
Wildcard keyword search in the list view of a table is not working for non-admin users. For example:
- Searching with *name returns results for admins.
- The same *name search returns no results for non-admins.
- However, non-admins do get results when using an exact match search like =name.
Has anyone else experienced this behavior or found a workaround?
