soql – Is there a possible way to search the name of a lookup fields using the search.query using apex in salesforce?
I had a lookup field on my object and I want to search the name of the lookup using search.query in apex, how can I do this?. In my debug, I am returning nothing. Below is my sample code.
String query = 'FIND \'Sonny McNeil\' IN ALL FIELDS RETURNING ASPHPP__ASPayment_Source__c (Id, Name,ASPHPP__PPContact__r.Name), Contact'; System.debug('query '+query); List<List<sObject>> searchRecords = Search.Query(query); System.debug('searchRecords '+searchRecords); return searchRecords.get(0);
Read more here: Source link