Apex Code Development You need to sign in to do that
Don't have an account?
Trying to use a wildcard in SOSL with 2 characters.
I have a similar query to:
I am having a hard time with a SOSLIf I run that query I get no results. If I change it to below I get 2 results.
If I remove the WHERE clause with just FIND {O\-*} it returns all of the results.
FIND {O\-*} IN ALL FIELDS RETURNING Opportunity(AccountId WHERE Sales_Credit__c='a1mG0000004VU...' ORDER BY LastModifiedDate DESC NULLS LAST).
I am having a hard time with a SOSLIf I run that query I get no results. If I change it to below I get 2 results.
FIND {O\-89*} IN ALL FIELDS RETURNING Opportunity(AccountId WHERE Sales_Credit__c='a1mG0000004VU...' ORDER BY LastModifiedDate DESC NULLS LAST).
If I remove the WHERE clause with just FIND {O\-*} it returns all of the results.
FIND {O\-89*} IN ALL FIELDS RETURNING Opportunity(AccountId ORDER BY LastModifiedDate DESC NULLS LAST).
I can succesfully run the query on our full sandbox. Any help will be greatly appreciated.