function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
valMotovalMoto 

Search results for a lookup

Wondering if anyone can provide me any clarification on how the search functionality may work since I seem to be getting unexpected results for a lookup field in an Account.

 

I have a custom Region object that contains values such a:

[1]: Midwest - Chicago

[1]: Midwest - Cleveland

[1]: Midwest - Detroit

[2]: South - Orlando

[2]: South - Atlanta

 

In my Account object, I have a lookup to this Region object.

 

Now the unexpected results I am getting are:

If I do a search on "1", I get results for all the Midwest regions.

If I search on "Chicago" I do not get any results

If I search on "*Chicago*", I get the results for the Midwest - Chicago entry

 

Why would a search on "1" return results, yet "Chicago" won't? In both cases they are not the first character.

 

Thanks!