Skip to main content Join us at TDX in San Francisco or on Salesforce+ on March 5-6 for the Developer Conference for the AI Agent Era. Register now.
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 answer
  1. Apr 12, 2016, 11:23 PM
    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