Using Like operator with Ajax Toolkit

Question

I am trying to use like operator in like query using Ajax toolkit, but unable to do so.

I am trying this:

var att_name = '%sample%';
var result = sforce.connection.query("select id, from Attachment where name like " + att_name);

Any help would be truly appreciated.

Answer 1

String literal values in SOQL and SOSL query WHERE clauses, including ordinary strings, picklist value API names, email addresses, IDs etc., must always be enclosed in (single) quotes, except in the case of using binding variables in Apex. This is mentioned in the documentation:

You must supply a value whose data type matches the field type of the specified field. You must supply a native value—other field names or calculations are not permitted. If quotes are required (for example, they are not for dates and numbers), use single quotes. Double quotes result in an error.

It is for this reason adding single quotes makes this query work.

Answer 2

This should work:

    var att_name = '%sample%';
    var result = sforce.connection.query("select id from Account where name like " + "'" + att_name + "'");

Answer 3

I would use Javascript template literals:

`select id from Account where name like '%${att_name} %'`

Notice the backticks ` used to wrap the string.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals

It keeps the code clean and makes it easy to maintain.

Answer 4

Fixed, this worked for me:

var att_name = '%sample%';
var result = sforce.connection.query("select id, from Attachment where name like'" +att_name + "'");