I can't get an Enhanced Lookup to work correctly, although I checked all questions and answers in SE so far and:
- Enabled Enhanced Lookups on this object
- am admin user
- Searching for the full values (no wildcard involved) of an existing text field (no non indexed fields)
- Added relevant fields to the "Search Filter Fields" list
- NO Lookup Filters are "in the way" of finding records
As the next screenshot shows there is nothing wrong with lookup filters here (even if the info message is displayed). Here you see how the record can be found by Name field also showing the text field with the search value "2020".
Best Answer
The implementation of Search, Lookup Filters and unseelctive search terms was the root cause. This is the answer we got from Support:
This is also documented in this Knowledge Article.
That was exactely our case. In a specific customer org (not in any of our dev orgs) we have thousands
Period__c
records with a text Year field of value "2020".Period__c
records are tied to theContract__c
by using a Lookup filter.If non of the first 200 returned
Period__c
records "belongs" to the currentContract__c
parent record We get ZERO results.We think this implementation is absolutely suboptimal and strongly reduces the use cases for Enhanced Lookups. Maybe we or someone else will create an IdeaExchange for that.