![](https://trailblazers.salesforce.com/img/userprofile/default_profile_200_v2.png)
Thank you,Bryanpublic 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;
}
}
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:
http://help.salesforce.com/HTViewSolution?id=000187460List<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'];