choefele/salesforce-geo

Salesforce Location Experiments

Storing Coordinates in Contact

• Find coordinate
• Update coordinate on Contact:

List<Contact> contacts=[select Id, Name from Contact where LastName='Test' limit 1];

if (!contacts.isEmpty()) {
   	Contact contact=contacts[0];
   	contact.MailingLatitude = 52.520904;
    contact.MailingLongitude = 13.351403;
   	update contact;
    
   	System.debug('Updated contact: ' + contact);
} else {
	System.debug('Contact not found');
}

• Query Contacts (reference):

SELECT Id, Name, MailingLatitude, MailingLongitude
FROM Contact
ORDER BY DISTANCE(MailingAddress, GEOLOCATION(37.775,-122.418), 'km')
LIMIT 10