代码之家 › 专栏 › 技术社区 › corolok

如何在SOQL RETURNING USING子句中转义ListView名称

soql salesforce

0

corolok · 技术社区 · 8 年前

列表名称: 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 '&lt;EOF&gt;' expecting '''

使用\:

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 什么都别说

1 回复 | 直到 8 年前

1

Gareth Jordan 8 年前

我很确定您需要使用api名称,而不是显示名称

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