How to write SOSL query for where condition with LIKE keyword ?
Hi guys,
I am newbie to SOSL query.. below is my SOQL query and am trying to replace it with SOSL query
[ SELECT Id, Name from SObject WHERE Name LIKE '%nirvana%' ]
I was not using dynamic object and my SOSL query was :
String searchKeyword = 'nirvana';
sObjQuery = 'SELECT Id, Name FROM Contact WHERE Name LIKE \'' + searchKeyword + '%\'';
Now I want to pass Object also dynamic in batch class:
private sObject strParameter;
public batchNotesInsert(sObject strParam) { //constructor
strParameter = strParam;
}
and I am facing errors with the below query can you please let me know where I am doing wrong (like in placing quotes in Query)
sObjQuery = 'SELECT Id, Name from' + strParameter + 'WHERE Name LIKE' \'' + searchKeyword + '%\'';
Thanks in advance :)
Regards
Nirvana K