We can’t find the correct SOQL query in the PropertyUtility class.

Question

Hello,i´m doing a trailhead.

The trailhead its: Create Relationship Queries with Custom Objects

And in the exercise show this error, but i dont know what its the mistake in my code.

We can’t find the correct SOQL query in the PropertyUtility class.

Someone can help me and show my error?

Thanks!!

Ankush Agarwal · Accepted Answer

Hi Vinicius,

You may try with below apex class:

public class PropertyUtility{
    public static void newListedProperties(){                
      List<Property__c>  newPropList = [Select Name,Days_On_Market__c,Broker__r.Email__c from Property__c where Days_On_Market__c < 31];
        for(Property__c p : newPropList){
         string  propEmail = p.Name +':'+ p.Broker__r.Email__c ;
            system.debug(propEmail);
        }
    }
}

ANANTHA REDDY PUSAPATI · Answer

Hi @Ankush Agarwal https://trailblazers.salesforce.com/profileView?u=0053A00000DanSfQAJ (or) Tech support Team, I am trying to understand the difference when I use my code I am getting the same exception but when I copy your code from above it's not throwing the exception, and works as expected. What is the difference ? Is the issue with the underlined bold keyword? Please advise. Thank you. Below is my Code public class PropertyUtility { public static void newListedProperties(){ List newPropList = [ SELECT Name,Days_On_Market__c,Broker__r.Email__c FROM Property__c WHERE Days_On_Market__c < 31]; for(Property__c eachProperty : newPropList){ String propEmail = eachProperty. NAME +':'+eachProperty.Broker__r.Email__c; system.debug('propEmail -->'+propEmail); } } } Appreciate any details on this to better study the issue and understand it. Thank you.

We can’t find the correct SOQL query in the PropertyUtility class.

Ask An Expert

Related Learning

More Help