There’s not very often that I am astounded by something VERY cool having to do with SOQL, but here’s a goodie. Salesforce is providing the capability for mobile apps to search for records in the vicinity of the current mobile user in SOQL. Take a look at this information:
This one might be news to many Force.com developers, but one of the most exciting new features in Summer ’12 (currently in Pilot) is the addition of a Geolocation custom field type. You can now geocode data in Force.com by adding latitude and longitude coordinates using that custom field type. Once the data is geocoded (say in the location__c field), you can then execute a SOQL query like the one below from the mobile applicationSELECT caseNumber, location__latitude__s, location__longitude__s FROM Case WHERE DISTANCE(location__c, GEOLOCATION(<latitude and longitude coordinates of mobile device>), 'mi') <= 10
The above query will return all Case records that are within a 10 mile radius of the mobile device. We’ll be providing additional details and code samples on how to use the new geolocation field type (pilot) in the near future, but hopefully the snippet above demonstrates some of the power of this new feature.
Tags: geolocation, gps, mobile, soql, tutorial
Posted in Summer 2012 | Comments Off on Geolocation in Salesforce Mobile Apps
The Salesforce 2012 release is available for most everybody now and it brings some pretty useful features. Let me provide an overview of my favorites.
Chatter Messenger – I like it, but it is just adding 1 more messenger to my huge list of messengers already open (Gmail, Facebook, Corporate IM, etc.)
Email Threads in Chatter – This is just an example of Chatter advancing as a modern social collaboration tool. Think Google Docs and the ability to respond to comments from emails or Facebook.
Chatter Multi-File Upload – Much needed feature, but let’s hope that document storage limits start dramatically increasing or there might be problems in the near future.
Advanced Relationship features – The ability to have Master-Detail relationships with the ability to detach a parent after a record is created. This is really a beautiful thing.
Tags: summer 12, summer 2012
Posted in Salesforce.com, Summer 2012 | Comments Off on Summer 2012 – Salesforce Release