Skip to main content 欢迎参加 3 月 5 日至 6 日在旧金山举行的 TDX AI 代理时代开发者大会,或通过 Salesforce+ 参与。立即注册
错误

出错了。请重试。

Hi,

I am new to apex and I need a little help with an error that will not go away.

 

public class ClientRelationshipController {

Public List<Prospect__c> getProspects() {

List<Prospect__c> Prospects=[Select Name,Property__c,Property_Name__c,Phone__c,Mobile__c,Prospect_Score__c,Email__c

From Prospect__c

Where Created_Date__c = Today And Relationship_Lead__c != :Relationship_lead_ID__c

And RecordType__c = 'Prospect'];

return Prospects;

}

}

Thank you,

Bryan
1 个回答
  1. 2016年4月12日 23:23
    Hy Bryan.

    You did not specify the error you're getting, but I'm assuming this is related to your SOQL query. 

    Salesforce doesn't allow direct field to field comparison in SOQL query.

    You can create a formula field for this:

     Formula Name: myFormula:

    IF(Prospect__c.Relationship_lead_ID__c != Prospect__c.Relationship_Lead__c , 'true', 'false')

    Final SOQL:

    List<Prospect__c> Prospects=[Select Name,Property__c,Property_Name__c,Phone__c,Mobile__c,Prospect_Score__c,Email__c

    From Prospect__c

    Where Created_Date__c = Today And myFormula = 'true'

    And RecordType__c = 'Prospect'];

    http://help.salesforce.com/HTViewSolution?id=000187460

     
0/9000