Skip to main content

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

0/9000