Skip to main content Únase a nosotros en TDX, San Francisco o en Salesforce+ del 5 al 6 de marzo en la conferencia de desarrolladores para la era del agente de la IA. Regístrese ahora.
error

Realizamos un giro incorrecto. Inténtelo de nuevo.

Bryan Jimenez preguntó en #Apex
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 respuesta
  1. 12 abr 2016, 11:23 p.m.
    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