Exam Certified Platform Developer II topic 1 question 84 discussion

Explanation: DISTANCE and GEOLOCATION can be used to filter and order. Ex: String queryString = 'SELECT Name, Email__c ' + 'FROM Account ' + 'WHERE DISTANCE(BillingAddress, GEOLOCATION('+lat+','+lon+'), \'mi\') < 20 ' + 'ORDER BY DISTANCE(BillingAddress, GEOLOCATION('+lat+','+lon+'), \'mi\') ' + 'LIMIT 10'; List<Account> accList =Database.query(queryString);

While it may seem that including DISTANCE in the SELECT clause (as in Option B) lets you "get the distance" as a return value, the core supported use cases in SOQL for these functions are for filtering and ordering.

A: To filter results based on distance from a latitude and longitude → You can use WHERE clauses to filter records based on distance. B: To get the distance results from a latitude and longitude → The DISTANCE function returns the calculated distance in miles or kilometers.

Filter and order

Option C is not correct because it says “To order results by distance from a latitude or longitude”. This implies that you can order results by distance from either a latitude or a longitude, but not both. However, the DISTANCE function requires both a latitude and a longitude to calculate the distance from a location. Therefore, you cannot order results by distance from a latitude or longitude, but only from a latitude and longitude pair.

Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_geolocate.htm

SELECT Name, StreetAddress__c FROM Warehouse__c WHERE DISTANCE(Location__c, GEOLOCATION(37.775,-122.418), 'mi') < 20 ORDER BY DISTANCE(Location__c, GEOLOCATION(37.775,-122.418), 'mi') LIMIT 10