Dynamic Value in SOQL LIKE

Question

I am trying to fetch record in my trigger using SOQL using LIKE. The value I need to compare is a combination of three fields. I am trying the below code. Not sure what I am doing wrong

string DocName = ''+q.SBQQ__Account__c+' - '+q.SBQQ__Account__c+' - '+q.Name+'%';
Document d = [Select id from Document where Name LIKE ''+DocName+'' order by CreatedDate asc LIMIT 1];

what is the error? p.s. there are a lot of questions on dynamic SOQL - this is most likely to be closed as a duplicate. — glls, Sep 22 '17 at 03:26
@SantanuBoral Not exactly, the string I want to compare is a combination of the three fields. For example my string to compare would be Account - Account - Name — Afroz Kazi, Sep 22 '17 at 04:53

score 2 · Answer 1 · answered Sep 22 '17 at 03:33

2

This query isn't even dynamic SOQL. You just use bind syntax:

WHERE Name LIKE :docName

answered Sep 22 '17 at 03:33

Adrian Larson

149,971
38
239
420

score 0 · Answer 2 · answered Sep 22 '17 at 05:14

0

Hope your looking for this

string DocName ='\'' + q.SBQQ__Account__c +' - '+ q.SBQQ__Account__c + ' - '+ q.Name+'%\'';
Document d = [Select id from Document where Name LIKE :DocName order by CreatedDate asc LIMIT 1];

answered Sep 22 '17 at 05:14

NITHESH K

2,525
2
15
43

Dynamic Value in SOQL LIKE

2 Answers2