- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
02-18-2013 08:47 PM
We have a lookup of Address__c object on various Objects like Account, Contact etc.
When the user opens the lookup dialog box of Address object and tries to search using some keywords, it does not provide all the results.
However , when we query the same object in workbench we see all the required results.
Eg: On GUI: After we click and open the Lookup Dialog object from Contact record, we enter the "Street Name" in the Search Textbox and click Go.
Then we refine the search using filter criteria on some fields like HouseNumber Field (say 123) and Post Code field (say 1008) we get 1record.
When we do the same query on workbench using Street Name = 'StreetName' and PostCode__c = '1008' and housenumber__c = 123, we get 3 records.
Also, The Record type is same for all the records.
Any reasons why we do not see all the results in GUI as this impacts the search the Users perform due to their inability to search for their records?
02-19-2013 03:07 AM
I am not very sure, but I think when you are querying using SOQL, you are searching for exact match. The search lookup will find matching strings. Hence, sometimes the results will vary.
02-19-2013 04:09 AM
However If the search lookup is a LIKE Search and not a Exact search then it is not restrictive and should return a result instead, right?