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

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

  •  0
  • corolok  · 技术社区  · 7 年前

    列表名称: 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 '''
    

    使用\:

    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 回复  |  直到 7 年前
        1
  •  1
  •   Gareth Jordan    7 年前

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

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