Search code examples
salesforcesoql

How to escape ListView name in SOQL RETURNING USING clause

List name: mike's test view

FIND {*@*.*} IN EMAIL FIELDS RETURNING Lead(Id, Email, FirstName, LastName, Phone, Company USING ListView=mike's test view)

line 2:0 mismatched character '<EOF>' expecting '''

When escape with \:

FIND {*@*.*} IN EMAIL FIELDS RETURNING Lead(Id, Email, FirstName, LastName, Phone, Company USING ListView=mike\'s\ test\ view)

Phone, Company USING ListView=mike\'s\ test\ view)
                             ^
ERROR at Row:1:Column:110
line 1:110 no viable alternative at character '\'

Salesforce docs say nothing about it

Solution

  • I'm pretty sure you need to use the api name and not the display name so it would be 

    FIND {*@*.*} IN EMAIL FIELDS RETURNING Lead(Id, Email, FirstName, LastName, Phone, Company USING ListView=mike_s_test_view)