Search Results

https://www.salesforce.com/us/developer/docs/apexcode/Content/langCon_apex_SOQL_VLSQ.htm In no particular order: Don't believe, apply a debug log and experiment ;), fire off your batch and check th …

Check the list of date functions and date literals. Something like this? SELECT Id, Name, SystemModstamp FROM Account WHERE SystemModStamp = THIS_MONTH AND HOUR_IN_DAY(SystemModstamp) >= 14 …

apex:page's readOnly="true" probably won't help you. All the LIKE look as if they are the reason of timeouts, not only the size of Set of Ids.. A SOSL query might be better in your case and you can s …

Aggregate queries do not give you full result set by design. You should apply LIMIT clause for a start or query from Apex calling queryMore() / using for loop However something like that should get y …

SOSL reference mentions bit complex examples like FIND {MyProspect AND "John Smith" OR MyCompany} so if you're going through same object I suspect you could rewrite your search to a simpler form. Can …

No, you probably don't have all relevant permissions. There's special "Query All Files" permission. Create a permission set with it and assign to yourself.

SELECT AccountId, Id, FirstName, LastName FROM Contact WHERE Account.Sic = '6752' Read up about relationships, for example https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/s …

Something like this? SELECT Name, COUNT(Id) FROM Search_Term__c GROUP BY Name ORDER BY COUNT(Id) DESC LIMIT 5 (assuming you're storing the searched phrases in Name field) Here's whole SELECT refer …

When in doubt - discard the "cloud magic" and think about it as an Oracle database ;) If the text field's length is less or equal 255 characters (text/textarea type) you can use it in WHERE clause or …

Go "up" on Contact: SELECT (select Contact__c, Contact__r.Email from Distribution_List_Junctions__r ) FROM Distribution_List__c WHERE Name = 'Distribution List 1'

List<Detail_Object__c> details = [SELECT Id, Name FROM Detail_Object__c WHERE Lookup_to_Master__c IN :trigger.new]; No need to even extract the Ids into Set with trigger.newMap.keyset(); bind variab …

The results of the query are blank (there's a difference between having a list with 0 rows, with 1 null row in it or the list not even existing. List<Account> accounts = [SELECT Id, Name, LogoID__c F …

It's hard to say something without knowing how your data is structured... Can you use smaller LIMIT clause? I doubt it's actually helping in anything. Is this query within start() or execute()? Can …

Binding variables like that to SQL / SOQL ("prepared statements") is a common method to protect yourself against SQL injections plus it's a performance benefit. …

http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_gov_limits.htm At the moment - 50K in total. This might be limited further for example if you'll query large textarea fields and run …