function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bryan JimenezBryan Jimenez 

Soql Query Help

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
Best Answer chosen by Bryan Jimenez
Temoc MunozTemoc Munoz
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