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? ...
Has any one done SQL to SOQL Conversion for Salesforce.com Objects? ...
Does anyone know good ways/tools/approaches for using Crystal Reports with Salesforce.com? I know that Crystal Reports for Salesforce exists but I'm wondering what other possibilities there are... ...
Is there an efficient way to page through results from a SOQL query without bringing all the query results back and then discarding the majority of them? As an example, I'd like to be able to to page through the complete list of contacts showing 10 records at a time. I don't have the need to sort by any particular field. ...
Hi All, Looking to do a security audit of all user permissions. I think I can use the Salesforce PHPToolkit 11 API to generate the report but new to Salesforce and a little confused on where to start. In Salesforce Setup Under: Administration Setup -> Manage Users -> Profiles -> Profile Names If you click on each user name you can ...
How to fetch more than 2000 records through SOQL .... Is there something query more ??? Plz help ...
I'm trying to write some apex code using this query and not getting anywhere: List<Task> tasks = [SELECT id, whatid, who.account.parent.name FROM task WHERE who.account.parent.name LIKE 'Procter%']; I'm not surprised this doesn't work, but can't seem to find documentation anywhere that explains how I would go about this. Does anyone ...
Hi I am having a problem using Adobe Air to get contact information. If I import the contacts from Saleforce all I get is the Id of the Account to which they belong. How do I convert this Id to the Account Name. There are similar problems with other objects like Cases, Opportunities, etc where key fields like Owner, Account, etc just...
I am running a Dynamic SOQL query in my apex test code, and the LIMIT clause is not working. It does however seem to work when using it in the production code. The Query is similar to below. I dynamically build up the where clause using some terms from a form. string query = 'SELECT name, billingstreet, billingpostalcode, phone '; qu...
I'm having trouble getting the results I want from a Salesforce/Apex/SOQL query. I want: A list of Contact objects containing only contacts who are CampaignMembers of a set of campaigns; and they should have the data from that Campaign member easily accessible. (my eventual goal is a VF page with a list of all Contacts connected to any ...