I have been looking for a decent guide to salesforce.com's SOQL query language and a schema for their tables but I can't find anything that is remotely decent. Does anyone know how I would go about getting docs?
+5
A:
I have a good book on this subject sitting on my desk at work, Unfortunately I'm currently at home. As soon as I get to work tomorrow morning (UK), I'll edit this answer to give details.
This book is called force.com Cookbook, published by Salesforce itself. It's available for free at that link. Here are the chapter titles:
- Getting Started
- Developing On-Demand Apps
- Best practices for Writing S-Controls
- Best practices for Writing Apex
- Searching and Querying Data
- Improving Data Quality
- Customizing Buttons and Links
- Customizing Salesforce Pages and Fields
- Integrating with Other Services
- Writing Web Controls and Client Applications
- Debugging S-Controls and Apex
- Packaging an App for the AppExchange
- Getting Started with VisualForce
The book has dozens of SOQL examples and discussions, in fact a bit too code-heavy in places. But I learnt a lot of good stuff.
For raw details about your specific Salesforce schema (each one is customised), you should look at the WSDL that's generated for you. I've also used a couple of the apps shown here.
RoadWarrior
2008-11-20 22:34:02
I would be eternally grateful and, at risk of having paid the ferryman, I have voted you up. I too am in the UK, so tomorrow is fine.
Simon
2008-11-20 23:01:23
I hope that was enough. If so, you're allowed to mark my answer as "accepted" :-)
RoadWarrior
2008-11-21 10:16:02
+2
A:
The Salesforce.com Web Services API Docs contains the reference docs for SOQL, has lots of samples.
superfell
2008-11-27 18:32:20
A:
If you have any specific questions about SOQL that don't get answered here, you can check out the developer discussion boards at: http://community.salesforce.com/sforce?category.id=developers
Ryan Guest
2008-12-19 21:46:14
+2
A:
During my development of a custom solution against the Salesforce API, what helped me a lot to decipher the Salesforce database tables, custom objects and SOQL (includes examples) behind the scenes was sforce Explorer; http://sforce.sourceforge.net/
Nothing like SQL Server Enterprise, or the newer Management Studio tools, actually a tiny application. It helps peel away a lot of the obscurity.
You will need a Salesforce Developer account, or Enterprise account with API access (and token) to login and use sforce Explorer
subv3rsion
2009-12-03 17:26:50