Apex Code Development You need to sign in to do that
Don't have an account?
Is '*' as a wildcard allowed to search all values in a Lookup?
Hello everyone,
This may sound a bit redundant as I have found the followind idea to show all records at the lookup window.
https://success.salesforce.com/ideaView?id=08730000000kxgoAAA. So this question may have an answer already.
But, I have a user that assures that at one point the Lookup search popups allowed them to search every record by placing a '*' wildcard. I can't seem to be able to make this to work. I found that if I search 'S*, I will get every record that contains that letter S.
Does anyone know if at some point the '*' was working but was later removed for performance purposes? Or is there a wildcard combination of characters that allow getting all records?
Thank you very much.
This may sound a bit redundant as I have found the followind idea to show all records at the lookup window.
https://success.salesforce.com/ideaView?id=08730000000kxgoAAA. So this question may have an answer already.
But, I have a user that assures that at one point the Lookup search popups allowed them to search every record by placing a '*' wildcard. I can't seem to be able to make this to work. I found that if I search 'S*, I will get every record that contains that letter S.
Does anyone know if at some point the '*' was working but was later removed for performance purposes? Or is there a wildcard combination of characters that allow getting all records?
Thank you very much.
Wildcards such as '*' and '?' are supported for searching a value, but they also have some limitations.
Please refer to the following link as it may be helpful in solving your problem:
https://help.salesforce.com/articleView?id=000230635&language=en_US&type=1
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Deepali Kulshrestha