I wanna run my SOSL to search for a string obtained by function parameter

Question

I wanna search for a particular string obtained by my function parameter in Contact & Lead FirstName & LastName fields.. The difficulty is how to compose a SOQL statement for that,as I am getting problem with the following piece of code:

However when I pass a string,it works perfect,it is not just allowing the parameter obtained to be passed in the query..

Am I doing something wrong? Please let me know...

Answer 1

I'm pretty sure there's a duplicate out there somewhere, but the answer is you have to bind to the query:

List<SObject[]> searchList = [FIND :param IN ALL FIELDS RETURNING Contact(FirstName, LastName), Lead(FirstName, LastName)];

Do not use the quote (') or the ({}) characters. You can bind directly to a variable.

Answer 2

I am not very familiar with SOSL but i think It can be done using dynamic SOSL.

for eg.

String searchquery='FIND\'Edge*\'IN ALL FIELDS RETURNING Account(id,name),Contact, Lead'; 
List<List<SObject>>searchList=search.query(searchquery);

Similarly you can do like this:

String searchquery='Find '+param+ 'Other part of query'