Skip to main content Únase a nosotros en TDX, en San Francisco, o en Salesforce+ los días 5 y 6 de marzo en la conferencia para desarrolladores sobre la era de agentes de IA. Registrarse ahora.
error

Vaya, se ha producido un error. Inténtelo de nuevo.

Bryan Jimenez ha preguntado 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, 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