database.query using like and % giving error

I am trying to do a soql query using database.query so that I can dynamically build the search parameters. the problem I am having is with the following portion:
qry3 = qry2 + 'where name like :%' + sobj.name + '% OR Account__c = :' + sobj.Account__c + ' OR Opportunity__c = :' + sobj.Opportunity__c + ' limit 50';
when I put it in this way I get the error : no viable alternative at character '%'
I have tried:
qry3 = qry2 + 'where name like :\'%' + sobj.name + '%\' OR Account__c = :' + sobj.Account__c + ' OR Opportunity__c = :' + sobj.Opportunity__c + ' limit 50';
when I do it this way I get the error: unexpected token: '%test test%'
and I have tried it this way:
qry3 = qry2 + 'where name like :\'%\'' + sobj.name + '\'%\' OR Account__c = :' + sobj.Account__c + ' OR Opportunity__c = :' + sobj.Opportunity__c + ' limit 50';
and I get the error: unexpected token: '%'

Any idea what I need to change to get the like statement to work?

January 2, 2014
·
Like
0
·
Follow
1

Best Answer chosen by SirTrav

srinu_SFDC
I was in haste earlier, Please try this(Only difference from your 2nd version is removed the colon)
String qry3 = qry2 + 'where name like \'%' + sobj.name + '%\' OR Account__c = :' + sobj.Account__c + ' OR Opportunity__c = :' + sobj.Opportunity__c + ' limit 50';

January 2, 2014
·
Like
0
·
Dislike
0

srinu_SFDC
Try this: String name = '%'+ sobj.name + '%';
qry3 = qry2 + 'where name like :' + name + ' OR Account__c = :' + sobj.Account__c + ' OR Opportunity__c = :' + sobj.Opportunity__c + ' limit 50';

January 2, 2014
·
Like
0
·
Dislike
0

This was selected as the best answer

SirTrav
Thank you that did the trick.

January 2, 2014
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

database.query using like and % giving error

All Answers

You need to sign in to do that.